Activity overview
Latest activity by GaryC
Hi,
Its a 2000 box so I ran
SELECT COUNT (*) FROM dbo.sysperfinfo
and this returned 0.
Incidentally the server you mentioned in the email isnt the one in question, and the real issue is with server load on the one being monitored.
Does the response about performance counters not being returned mean that SQL Response queries the server more often if performance counters are not being returned??
Any suggestions on reducing load on the server being monitored would be appreciated, perhaps a 'light monitoring' mode to just give basic information, i.e. not including recommendations, etc.?
Cheers,
Gary. / comments
Hi,
Its a 2000 box so I ran
SELECT COUNT (*) FROM dbo.sysperfinfo
and this returned 0.
Incidentally the server you mentioned in the email isnt the one in question, and the real issue is with server...
Hi,
I have sent the logs as requested.
Cheers,
Gary. / comments
Hi,
I have sent the logs as requested.
Cheers,
Gary.
SQL Response - effect on SQL boxes being monitored
Hi,
I have been trying SQL response and it noted unusually high cpu utilisation.
I ran a SQL profiler session and 90% of the SQL traffic was coming from SQL response, i am presuming it was gatherin...
Hi,
I wondered if since Red Gate created its own backups they might be in a different format maybe, and than then they might be fully interchangeable?
Cheers,
Gary. / comments
Hi,
I wondered if since Red Gate created its own backups they might be in a different format maybe, and than then they might be fully interchangeable?
Cheers,
Gary.
Need to backup 2005/2008 and restore to SQL2000
Hi,
We have a live server which is currently SQL 2000 but we need to use better hardware, so we are going 64-bit. This means a move to SQL 2005 or 2008, but...
...on a monthly schedule we copy dat...