iqtedar (8/4/2010)

---

We have dedicated LUN for tempdb. We never had any space issues,however we are facing some peformance issues. I wanted to specify max size of tempdb and disable autogrowth,...

I soooo prefer the CASE syntax to PIVOT! 🙂

I did learn something new, which honestly doesn't happen all that often for me when it comes to the...

Grant Fritchey is "article enough" for me, and he should be for you too. And if not, Jeff...

1) If you are tasked with maintaining a VLDB but don't have the skills/experience to do that, PLEASE have your company hire a professional to help mentor you and also...

Have you tried ProcessHacker? http://sourceforge.net/projects/processhacker/

I don't think it is bad code. Works fine to accomplish the objective. You may argue with the REQUIREMENT...

1) exactly what command is being issued to do your index maintenance on the large table?

2) are you using SORT_IN_TEMPDB option?

3) what is your tempdb IO configuration -...

sanketahir1985 (8/3/2010)

---

thanx Kevin

But i took that decision of splitting tempdb in multiple files is becoz, i was getting bufferlatch wait type

also it was indicating PAGELATCH_EX,PAGELATCH_UP also resource_Type was 2:........ and...

Sounds like you are doing this a row at a time? Can I ask why? lots of things get bad when you do row-by-row processing. Can you...

>>I do not know much about statistics and I would have thought (I dislike the word "assumed", but that is what this is) that the AUTO_UPDATE_STATISTICS setting on the database...

See here and the related 2 blog posts for some goodness on deadlock troubleshooting: http://blogs.msdn.com/bartd/archive/2006/09/09/Deadlock-Troubleshooting_2C00_-Part-1.aspx

I too thought at first this was a simple resource group problem. Odd how it turned out to be a DNS issue!

I am with Barry on this. Sounds like you have simple requirements and a simple solution is best. Restore backups. Or perhaps do a straight-forward implementation of...

My recommendation is to stop using maintenance plans altogether. They suck in a bunch of ways. Go to http://ola.hallengren.com/ and get his maintenance stuff and learn and use...

Red-Gate and ApexSQL both offer API-scriptable Data and Schema DIFF programs that you can use to automatically sync stuff like you are looking to do. I have to say...