2
votes
0answers
92 views

SQL Server Database Mail Log is flooded with errors (20-30 per second) when mail server goes down

We're using SQL Server 2005. Every so often our mail server goes down, and when this happens, as soon as our SQL code tries to send dbmail, the Database Mail Log has an item which looks like this: ...
2
votes
2answers
89 views

Running query progress indication

I have a query: SELECT * FROM OPENQUERY ( oracle, 'SELECT * FROM [some_table]' ) It runs for about 7 hours. I only need to run this query once to import data into a new system when we ...
1
vote
1answer
347 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
378 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 ...
3
votes
1answer
2k 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, ...