May 14, 2009 at 1:14 am
Hi friends,
Am load testing a complex query in sql server.
I monitor the time for the amount of data.
But do we have any other parameters to be monitored while testing ?
I have to submit the complete analysis of the complex query to my customer.
Kindly tell me the other parameters and how to monitor those parameters.
Thanks.
May 14, 2009 at 6:32 am
without wishing to be too unkind, if you're asking the question you're the wrong person for the job.
I suggest you might get hold of the SQL Server 2000 performance tuning technical reference, it's still the best grounding on performance I know.
It all depends what you actually want to know. Queries tested in isolation may not work the same in a busy multi user environment. For initial analysis of queries I look first at io, duration is more tricky depending on the application - how a query runs on a server may be very different to how it runs for user from an application.
I'd also look at the query plan to see if anything obvious shows. That's my first two steps when testing in isolation, in prod I'd maybe also looking at any possible contention and use of locks / excalation recompiles etc.
[font="Comic Sans MS"]The GrumpyOldDBA[/font]
www.grumpyolddba.co.uk
http://sqlblogcasts.com/blogs/grumpyolddba/
May 14, 2009 at 6:56 am
That's a huge topic. If you're expected to deliver all this stuff NOW and you don't know how, you really are over your head. However, this is a high level introduction[/url] to performance monitoring. It might help.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply