Browse by Tags

• cache
• databases
• error
• error log
• performance
• plan
• recovery
• sql server
• sqlagent
• suspect

Recovery of database 'dbname' (10) is 17% complete (approximately 31602 seconds remain). Phase 3 of 3. This is an informational message only. No user action is required.
05 September 07 01:13 AM | SQL Master | 2 Comments   

Though the message specifies as an informational message only and no user action is required, you should take some action to avoid current behaviour of databases within your environment. Also check whether you have enabled the AUTO_CLOSE property for Read More...

Filed under: performance, sql server, message, databases, sqlagent, recovery, suspect, error log

SQL Server has encountered '%' occurrence(s) of cachestore flush for the '%' cachestore
14 May 07 03:22 AM | SQL Master | 0 Comments   

One of our Operational Staff has alerted stating they see lot of following message on one of the SQL Server. SQL Server has encountered %d occurrence(s) of cachestore flush for the '%s' cachestore For a moment I was bit perplxed with the message content Read More...

Filed under: plan, cache, perfmance, message, error