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: ...
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 ...
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 ...
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 ...
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, ...