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...
Hello, Has anyone seen this error? We are seeing it every 2 seconds. Event Type: Error Event Source: MSSQLSERVER Event Category: (3) Event...
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...
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...
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...
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...
Hello, This is probably a very basic question, but ironically there is so much information on SQL Server security that I don't know where to start....
Hello, From what I have read, I think that the transaction log file for my database has grown large - more than 2GB, or slightly larger than the...
Hello, I just read this advice: quote:Common cause of large transaction log file (.ldf) Unfortunately the sql server default (except local...
Separate names with a comma.
