Thank you,

http://msdn.microsoft.com/en-us/library/ms175008.aspx

I have used script listed on this page but i have modified it to replace cursor and run it for all databases in production server rather than just one...

I did not see any performance issues so far as the server is in Pre-Production. But I...

Could you please tell me how to diagnose this issue..

Hi Vivek Shukla,

As you are maintaining Share Point databases in SQL Server, I have...

Plz advice me....

Anti-Virus software is McAfee

We have Anti-virus installed on all nodes though Microsoft recommends not to install Anti-Virus on clusters. How can I prove, Anti-Virus or some other OS related thing is causing Memory...

Ok, we had some issue with hardware on node 1 and all the resources were moved to node2,then I did get page life expectancy alarm form spot light and Memory...

Thank You,

Node1(active):

Memeory: ...

I'm getting High Disk Quelength (for the Data drive, having .mdf files) alarms from Spot light whenever the Index rebuild/reorganize job runs.

Could you please post the Script you are using...

Could you please advice me..

thanks

Thanks

I want to know how experienced DBA's deal with Deadlocks.

When a dead lock occurs, how you get notified:

1.Only by examining the error log

2.Notification by email,by frequently running a...

I agree with you. Thanks for your help.

thank you,

Yes, every hour the log backup writes to a new file.

...

all the Drives are on SAN...Its olny faied twice and I want know why its failed those 2 times?

as soon as I see this error, I ran DBCC CHECKDB for...