Take the 2-minute tour ×
Server Fault is a question and answer site for system and network administrators. It's 100% free, no registration required.

After some hangs on our public web application, it was recommended by a friend that I use Profiler in order to view db activity from each user (including sprocs and duration). Is there a more widely used database server profiler that I could use in order to better pinpoint issues like this?

share|improve this question
    
But you can not run trace on Production server , coz it takes a lots of server resource which will in turn causes the over all performance problem in database –  user52026 Aug 23 '10 at 10:24
    
I wouldn't say you can't run it on a production server, but you should be careful about running it. If the server is normally very heavily loaded then keep the duration of runs short. If the server usually has spare capacity then there will probably not be any issue. –  pipTheGeek Aug 23 '10 at 11:31

1 Answer 1

up vote 4 down vote accepted

I've never had the need to use anything other than SQL Server Profiler. It's included specifically for purposes such as you mention. You can see everything you need to see with Profiler. Have you run a trace against your server yet? There are quite a few options that you'll need to configure for your trace in order to narrow down the problem. It won't necessarily happen on the first trace, either. It's likely you'll have to do some tweaking of your trace config and rerun a few times in order to see the information you need.

share|improve this answer
    
Thanks, I'll have to read more on that. –  lush May 29 '09 at 15:40

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.