sanketahir1985 (8/2/2010)

---

Locations of tempdb files

namefileidfilename

tempdev1D:\TempDB\tempdb.mdf

templog2C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\DATA\templog.ldf

tempdb23D:\TempDB\tempdb2.mdf

tempdb34D:\TempDB\tempdb3.mdf

tempdb45D:\TempDB\tempdb4.mdf

tempdb56D:\TempDB\tempdb5.mdf

tempdb67D:\TempDB\tempdb6.mdf

tempdb78D:\TempDB\tempdb7.mdf

tempdb89D:\TempDB\tempdb8.mdf

C:\ and D:\ drives are on same disk

RAM -16GB (10GB dedicated to SQL)

CPU- 8 Cores,16 threads

but why tempdb will cause insert operation to...

Hmm, I thought the quirky update WAS primarily a performance tool since it can solve problems where you need a triangular join or actual TSQL cursor to get the right...

I don't typically open excel spreadsheets from people I don't know, but I can say that several of the things you list indicate unacceptable IO performance. More RAM could...

Ideal values are those where you are having acceptable performance. Anything else is useless. 🙂 For some systems 5 ms per read/write is too slow, for others 100...

you cannot do what you ask (asynchronously return 70 data streams from a single sproc). so change your calling structure to hit 70 sprocs that each return their own...

G33kKahuna (7/26/2010)

---

SQLGuru, thanks for the advise. No offense to Bart, but those articles (all 3) are...

Here is the Bible about deadlock troubleshooting - http://blogs.msdn.com/bartd/archive/2006/09/09/Deadlock-Troubleshooting_2C00_-Part-1.aspx. Note it has 2 other parts.

You might want to consider getting a professional to help you out.

IIRC the way frag is presented/calculated on heaps is a bit different than for clustered tables. Bit early this morning so could be confuzled here. 🙂 You...

CXPACKET: You have either too little ram, too poor an IO configuration or both. Drop MAXDOP to half the cores (non-hyperthreaded here) and try that.

For network packets, quite...

Tara-1044200 (7/25/2010)

---

So I think i can configure MAX DOP to 7 as i have 8 and if required when necessary people can use query hint so that they can use...

Mani-584606 (7/25/2010)

---

Hi,

We have SQL Server 2005 EE x64 with SP3 instance having Share point 2007 databases.

We are getting many Dead locks when Crawl job runs.

Generally, Crawl job only does indexing...

What about the chance to rub elbows with TheSQLGuru?!?! 😎

sam_mastermind (7/12/2010)

---

May be the way I framed it, looks like as you said(homework ?/ Exam ? / Interview ?). But truly I want to know it............... and i think that...

mzak (7/21/2010)

---

Kevin Rathgeber (7/21/2010)

---

mzak (7/21/2010)

---

Kevin Rathgeber (7/21/2010)

---

I have a comment regarding your T-SQL

In trying to keep all things equal, Shouldn't you declare a variable at the beginning of your function...

looks like intraquery parallelism blocking. Usually caused by either bad plans from parameter sniffing or suboptimal indexing (or both). You should do an indexing analysis session. Also...