By design SQL Server 2005 takes all the memory allocated to it's buffer pool(Max Memory setting) whether it requires or not.

Considering above statement, Why one of the 4 instances...

thank you,

So is that normal to have low PLE while running DBCC CHECKDB? after DBCC CHECKDB completes, then the PLE starts increasing gradually. Can we ignore low PLE while running...

Is this normal for the procedure cache value to go lower when ALTER DATABASE database_name SET OFFLINE command runs?

Thanks Paul,

We have MOSS 2007 (Share point) databases in our clustered SQL Server 2005 and the MOSS 2007 documentation in the link http://technet.microsoft.com/en-us/library/cc298801.aspx

says that Share point uses the...

Hi Matt,

I went through the given link and we are using Spot light for Monitoring our clustered SQL Server 2005 servers.It's showing normal message for log backups taken via log...

Do yuo get the same info if you use the event viewer from the actual server itself? You usually get the "missing description" message if your local machine is missing...

Generally, tempdb is not happiest on the SAN at all. Direct-attached storage is often a better solution. If your SQL Server is clustered, however, you currently have no choice. See...

We have mdf & ldf files of TempDB are on single drive T & 8 processors

For best performance, place the tempdb on a RAID 10 array. The number of tempdb...

thank you,

How to know whether tempDB is heavily used by the application or not? where to check this?

I went through the document but I did not find how...

It's>300

Yes, PLE reaches >300 in <2 mins

3) Are the machines...

Thanks Manu,

But it's a VB Script. Can we run the VB script from SSMS?

Thanks

I appreciate your help on this because the old bak files are not getting deleted as the job is failing with the above message and the space is full on...

thank you,

I found the exact link...

http://www.microsoft.com/sqlserver/2005/en/us/special-considerations.aspx#reporting

thanks

thanks for your hep..

But is there no way to find exactly that these Statistics are up to date and these Statistics are outdated in a particular database?