One last note – true load testing requires a well-thought methodology. There are also some great third-party tools such as Mercury Interactive’s LoadRunner and WinRunner and Quest Software’s Benchmark Factory. SQLIO.exe is an unsupported tool provided by Microsoft to accomplish this and is now available at The most popular tool for performance tests against the IO subsystem with an IO stress tool to test system performance before deploying SQL Server is called SQLIO.exe. There are several free tools from Microsoft that can help. The best next step toward understanding the performance potential of your SQL Server database is to actual perform load testing on the database and application.
A well-tuned design doesn’t always mean that your database will perform quickly once implemented. Most dba’s have experience with designing a well-tuned SQL Server database.
0 kommentar(er)
