One of the most common questions I receive is if there any tool available to generate load on SQL Server. Absolutely there is a fabulous free tool available to generate load on SQL Server This tool was released in 2008 but it is still extremely relevant to generate the load on SQL Server as well works fabulously.
The best part of this SQL Server Load Generator is that users can run multiple simultaneous queries again SQL Server using different login account and different application name. The interface of the tool is extremely easy to use and very intuitive as well.
One of the things which I felt needed improvement was a default configuration. As every single time when I was adding a query the default settings were showing up and I had to manually change that. However, when I went to Menu >> Tools >>Options I was really happy as it has options to change every single default which is available. Here one can give default username, password, database name as well various settings related to configuration. Additionally application logging is also possible through the options.
A couple of other important points I noticed was the button to reset counters as well status bar containing useful information of Total Threads, Completed Queries and Failed Queries. I use this frequently for my load testing. What tool do you use for SQL Server Load Generator?
Update: The original product link is moved so you will have to search on google now.
Reference:Â Pinal Dave (https://blog.sqlauthority.com)
9 Comments. Leave new
blocked downloading in office…. :(
Looks interested and new to me. But what is this the use of this tool. Is it to insert random data into the database or for performance testing?
Hi Pinal
Excelent tool!, I’m from El Salvador, could you please write about Execution Context ?
Thank you, I read your blog every day
Microsoft when releases a free tool it more feels like Microsoft is doing a charity/favor, they have some worst tools in the market, even though they claim they design user friendly tools, anyways.
To start with the worst is Profiler, and the worst of worst I found was Upgrade Advisor, it leaves you no where. Tablediff.exe (have you ever heard this before), the list goes on and on….
I mean, I better spent some money and get Quest products (even though I have never used any, but they say “Grass is always green on other side”), they charge money but they do justice to the tool and more important they listen to our request/complains, Microsoft is….. (Fill up the blanks)
Imran,
The SQLLoadGenerator isn’t released by Microsoft. It’s a project that is hosted on a site run by Microsoft to host Open Source software..
There is a difference.
The SQLLoadGenerator project was written by someone who had spoken at the PASS conference.
I downloaded the tool to test TDE on SQL Server database. I want to see how much of impact I will see. I am load testing the server without TDE enabled for the database to get baseline reference numbers. I will then enable TDE and load test again. This tool looks like will do the job for generating load that I need for my testing.
what’s the best place to use this tool?
Can the tool support login via Windows Authentication instead of SQL Server Authentication
Thanks
The application logging is not working and keeps throwing error that access to the log path is denied. I can only see completed queries and failed queries.