Tagged Questions
-8
votes
2answers
127 views
How can I check for SQL Server performance problems using T-SQL? [closed]
I know how to use the Profiler, Performance Monitor, and Activity Monitor. I want to find a way to troubleshoot performance using T-SQL. How can I check for Microsoft SQL Server performance problems ...
2
votes
1answer
182 views
How to monitor INSERT failures?
An application INSERTS a parent record then child objects. Both these procedure call different stored procedures. Parent can have many child objects. Typically both parent and child would be inserted ...
1
vote
1answer
168 views
Using sys.dm_os_performance_counters and DIFF to display logins per second
PROBLEM
Running my script below i can see the number of logins as an accumulated number to my instance:
SELECT cntr_value AS [LoginsPerSec]
FROM sys.dm_os_performance_counters
WHERE
...
1
vote
1answer
173 views
What is connection time?
We are currently trialling ManageEngine SQLDBManager Plus. On the dashboard for a server it shows connection time in milliseconds (currently 15ms).
Can anyone tell me what Connection Time represents ...
6
votes
1answer
161 views
Is there a quickish, straighforward way to measure Transactions Per Second on SQL Server 2000?
The sys.dm_os_performance_counters DMV introduced in SQL Server 2005 makes this task somewhat trivial. However, my Google-Fu has been blocked in finding a way to do this in SQL Server 2000.
How can ...
3
votes
1answer
685 views
How to find the detail cpu high process name which occupying most resource in the SQL Server database?
I'm running into a problem when using the following SQL to identify CPU usage in the production SQL Server 2005 env.
DECLARE @ts_now bigint;
SELECT @ts_now = cpu_ticks / CONVERT(float, ...
4
votes
1answer
1k views
How can I monitor the call count per stored procedure per timespan?
In order to diagnose some performance issues I would like to get a better understanding of the number of times certain procedures are called compared to the system performance. Is there a way to get ...
