Hi,

I think I sounded bit negative on parallelism in my post, it was not in my intention to say that you should always turn it off as a general fix...

Hi,

You can use Windows Performance Monitor to see how much SQL Server uses memory. There's a counter in SQL Server: Memory Manager called Total Server Memory (KB) that shows how...

Hello,

I'd start by monitoring disk I/O of the drive that holds TEMPDB files now to see if you get heavy usage to your TEMPDB files. We have some high usage...

Hello,

In my opinion, from SQL 2005 and onwards, you can get pretty decent data protection with using both database mirroring and transaction log shipping. What I personally prefer, when looking...

Hi,

You most certainly can put cluster nodes in different geographic locations. However when doing so, you should pay special attention to get rid of all the possible SPOF's. I've been...

Hi,

Parallelism can cause interesting issues in your environment. I've seen it cause rather severe blocking (and Im quite certain it caused deadlock situation once) in some databases myself, even though...