chileu17 (10/20/2008)

---

yeah we are thinking on calling some MS performance expert on this matter, because we don't seem to get a better performance in any of our attempts. But just...

I recommend (if not done yet) that you do a forced-failover (and fail back) under load to ensure everything is truly functional. Glad you had a (relatively) simple resolution!

nice little snipped there! 😉

Probably the BEST thing you can do (if able) is to a) max out the servers RAM (which is hopefully many, many GBs) and b) add more spindles to the...

nilmov (10/20/2008)

---

i have a citrix server database and it has mostly inactive transactions and also it grows tremendosly . i have the disk space of 200 GB for log drive...

Steve Jones - Editor (10/20/2008)

---

Shrinking the transaction log regularly doesn't buy you time, it grows again as the two above mentioned.

The only time you shrink it is when some rare,...

I am with Steve here: call Microsoft Support. You have an incredibly esoteric situation that even they may not have encountered. Uninstalling/reinstalling SQL Server MAY work, but...

1) you almost certainly have IO stall issues given the TOTAL averages you have. Specify individual drives that have mdfs and ldfs on them for monitoring in the future.

2)...

Here is the Bible for deadlock troubleshooting: http://blogs.msdn.com/bartd/archive/2006/09/09/Deadlock-Troubleshooting_2C00_-Part-1.aspx

So it looks like the only difference between what you guys are saying and what the TheSQLGuru is saying is in the fill factor for the NC indexes.

Based on our...

If you are a SQL Server only shop, be sure to ask Embarcadero for SQL Server only licensing. This can lead to much lower costs than the full cross-platform...

More questions:

1) how much RAM on the box?

2) How good (or poor) is your IO?

3) take a look in Perf Mon at Physical Disk: avg disk sec/read and...

Since (it seems that) the data is populated...

At least 75% of my clients have multi-cpu servers with insufficient RAM or IO capabilities (or both!), and thus suffer from significant CXPACKET waits on largish queries. It is...

See here for some guidance: http://www.sommarskog.se/arrays-in-sql.html. Not sure if this has been updated for 2008 though.