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