There is a document from Quest that addresses this. On a Windows Server 2008 operating system, you may need to RDP with the /admin option. On top of...

I just encountered the same issue being discussed here. I was finally able to solve it. I did the following:

- RDP'd to the Domain controller for the SQL...

Thanks for your reply. But this doesn't add up for the following reasons:

A. They are displayed as indexes in SSMS

B. If I script one out to a query editor...

I am basically following something roughly like this now. About 18 months ago, I moved out of Application Support and into the Systems. I was immediately drawn to...

Thanks for your reply.

Would you recommend looking at any particular wait type in this view?

In this case, we have only one instance of SQL Server 2005 running on 2 nodes. Both servers have exactly the same specs. I also verified that the...

Thanks for the reply.

Unfortunately, we were forced to go 32 bit because our current ERP system is not supported on SQL Server 2005 64 bit. Ironically, 64 bit is...