sm_iransoftware (1/24/2015)
Hiwe are on emergency state.
Application is very slow and some times give time out.
in Database , which thing Should I examin in first step?
and then :
we want to filter All sp's and dynamic tsql running on my server (with exec).
1- what is the best filter that give me object name and number of execution . (an sp come only one time on one execution. because I want to report from this result)
2- How can I get locked transaction or long time of them from profiler
thank you
Open SSMS and then open the Object Explorer. Press the {f8} key to get there if it's not already open.
Right click on the server instance, select [Reports], then [Standard Reports]. From there, let your nose be your guide. Generally speaking, reports that are prefixed with the word "Activity" are associated with what's going on right now. Reports that are prefixed with the word "Performance" are associated with things that have happened in the past up until now. Some things that happened in the past may be missing from these reports if they've been driven out of cache or the machine has recently been rebooted or the SQL Server Service has recently been started.
Most of the reports don't require any setup because they're reading from the same DMV's that a lot of people write code for. There are some great tools to be had but these reports are free and great ways to do the quick'n'dirty thing to help you find problems and problem code.
--Jeff Moden
Change is inevitable... Change for the better is not.