No, I used DBCC OPENTRAN and it didn't show any open transactions.
I checked the IsTruncLog preoperty and it is set to 1. I started a trace that included the checkpoint pages/sec and the SQLServer:Databases Log...
Thanks for your reply. I verified that the recovery interval is set to 0. The database is relatively active ~ 350 transactions per second so I...
The recovery model is Simple. There is no backup routine - this is one of more than 100 servers that collects data and forwards it to a central data...
I have a SQL 2000 database where the transaction log usage continues to grow over time until the log becomes full. Results of DBCC...
Hi, One way to do this is to use OPENROWSET to read the contents of the XML file into a table, You can then assign the character string to an xml...
One server is Windows Server 2003 Enterprise R2 Standard Edition SP 1. The other is Windows Server 2003 Standard x64 Edition SP1. I can get values...
I'm using performance monitor to help diagnose performance problems on several different servers. I've created a counter log that captures samples...
Hi, I'm attempting to verify that the performance of a new server that we are planning to roll out is as good as or better than the existing server....
Separate names with a comma.
