2000 would use Torn_page_detection to check IO level corruption. Better change it to Checksum.

Yes, But i tested it in Express edition. Any limitation?

sorry for spamming... I misread he created stats.... need to check.

Sure,

USE [STATS_DB]

GO

Select DATABASEPROPERTY('stats_db', 'IsAutoCreateStatistics')

GO

Create Table Stats_Table ( a Int)

GO

select OBJECT_NAME (OBJECT_ID) ObjectName, * from sys.stats where [OBJECT_ID] = OBJECT_ID('Stats_Table')

If @@ROWCOUNT = 0

Print 'No Stats Available'

Else

Print 'Stats...

Can you run the below query and post the output.

select scheduler_id, runnable_tasks_count,status from sys.dm_os_schedulers where scheduler_id < 255

Sometimes, a busy CPU may give this wait type.

"Automatically created statistics was not updated regularly. Although the table is update everyday, last statistics date is last month. Is there a reson for this message?"

1. Have you enabled 'auto...

Even though 'Auto Create Statistics' is ON, You need to run a query to 'acutally' enabled.Optimizer will not create a statistics until any query fire against the table.

Thank you very much...:-)

Apart from 5000 locks threshold, in 32Bit, Lock escalation will happen if 24%of memory is used up by database engine,excluding AWE. In 64, its the over all memory by database...

Post here wait types of your backup session. Also, I hope there will be an option (BufferCount, MaxTransferSize) in third party tool. Try to reduce it to some extent which...

Log shipping will not work from 2008 to 2005 as backup files are not backward compatible.

Is your disk in mirrored database fast enough to catch up with principal database? What does the Avg. Disk Write Queue Length counter show?

Hi Gila,

Correct me if i am wrong, SQL Server Configuration Manager would be checkpointed by CheckPoint Manager in Failover clustering. so will it be a point to consider in...

got your point.

http://www.sqlservercentral.com/Forums/Topic1049838-1549-1.aspx

http://www.sqlservercentral.com/articles/Database+Mirroring/72294/

These may help you out.