I also saw this link on this issue: INF: Last Batch Date is Seen as 1900-01-01 00:00:00.000 http://support.microsoft.com/kb/306625 Hope this helps....
Thanks - I tried restarting SQL Server Agent using the Take Offline/Bring Online command in the Cluster Administrator (it's a clustered db). Is that...
Hello, I have set up some jobs on SQL 2005 Standard Edition SP2(9.0.3042) 64-bit, including hourly transaction log backups. I testedout the jobs by...
Hello, I saw this output for DBCC MEMORYSTATUS around the time of a blocking problem. Can anyone help me interpret these results, especially why the...
Hello, I am trying to learn how to find out why some queries are running really slowly. Below are the results of an analysis I ran based on Brad...
Hi, My other thread was locked because it was flagged as a duplicate post. Sorry, I didn't intend to make a duplicate. But I don't see discussion in...
Hello, Has anyone seen this error? We are seeing it every 2 seconds. Event Type: Error Event Source: MSSQLSERVER Event Category: (3) Event...
Sorry, I have temporarily moved away from the above question, but I will check on it as soon as I get back to it and will post a reply. In the...
Hello, Could someone point me to step-by-step instructions for setting up SQL Server 2005 in an active-passive cluster to use more than 2 GB of RAM?...
Hello, I ran DBCC SHOWCONTIG on a couple of tables that seem to be involved in long-running queries. Are there any general suggestions or...
Why is Task Manager bad? I know that more detail can be obtained through performance monitoring, but Brad McGehee (an author on this site)...
Hello, I am having trouble finding the SQL Server 2005 process in a cluster. When I check a non-cluster server with SQL Server 2000, I open the Task...
I checked Task Manager, and I see these processes causing a lot of paging: mssearch.exe - Mem Usage 52,888K - Page Faults 324,902,295 - PF Delta 0...
One additional question - it looks like Page Faults Delta is available in Task Manager but not as a counter when running performance monitoring. Is...
Hello, and thanks for your detailed reply. This particular server is not attached to a SAN. In terms of the memory details, we are running SQL...
Hello, I ran the audit steps named Identify SQL Server Hardware Bottlenecks and found that the server in question is averaging about 97 in Memory:...
Hello, We are seeing this error about every 2 seconds in the Application Event Log of the active node of our SQL Server cluster. Source: MSSQLSERVER...
Thanks - that is exactly what needed to be done. Turns out our networking guys did it before I told them, but I appreciate the information, since...
I am told that the drive has been added as a cluster resource and is online. The drive is visible from Windows Explorer on the server. But when I...
Hello, There is a new drive letter that was set up on our SAN, and although I can see the drive letter from the Windows Explorer on our server...
Separate names with a comma.
