November 3, 2017 at 1:07 am
Our Firm is using a Inventory Software with SQL Server 2008 as a Backend and .net Based Windows Application.
Networking is based on Workgroup concept with One Database Server connected to Other 25 systems.
right now the Software runs a bit slow and the software developer ask us to upgrade the hardware system and sql server.
How can i test the Sql Load and the hardware requirement for that specific load.
November 7, 2017 at 10:34 am
jaganeee - Friday, November 3, 2017 1:07 AMOur Firm is using a Inventory Software with SQL Server 2008 as a Backend and .net Based Windows Application.
Networking is based on Workgroup concept with One Database Server connected to Other 25 systems.
right now the Software runs a bit slow and the software developer ask us to upgrade the hardware system and sql server.
How can i test the Sql Load and the hardware requirement for that specific load.
One option on 2008 is to use a Reply Trace. It does have some requirements and takes a bit to get working correctly so research it if you go down that direction. Here are a couple of links to get you started:
Replay Traces
Using the REPLAY feature within SQL Server Profiler
There are a lot of third party products that also do similar testing. You may also want to just do some general stress testing. Adam Mechanic developed a free tool, SQLQueryStress quite awhile back but it's still fairy popular. In case you want to check that tool, it's up on GitHub:
SQLQueryStress
Sue
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy