Elizabeth.Block (5/16/2012)

---

Thanks, Grant, for your info. I didn't know that DTA wasn't good at a single query. I'll have to check out your books. I don't really do much query...

Jeff Moden (5/15/2012)

---

sqldba_newbie (5/14/2012)

---

I did come across few articles related to capacity planning but couldn't find something what i was looking for. I am more inclined to buy a third...

Robin Sasson (5/15/2012)

---

Have you had a look at RedGate SQL Monitor or the Idera products?

They both provide a good set of admin tools for reporting of disk, CPU and memory...

I am confused, you said you have another user and you want to give access to that user, anyways if...

make sure when you create a linked server from your 2008R2 instance you have the login set to 'userM' going to your 2000 instance...this should work

You can refer http://www.sqlservercentral.com/Forums/Topic845879-338-1.aspx for dead locks, it depends on which version of sql server you are using.

seth delconte (5/2/2012)

---

I guess it may depend on what sort of process(es) are kicked off in the batch...if they are able to be executed asynchronously, as with a stored proc...

Evil Kraig F (4/30/2012)

---

sqldba_newbie (4/30/2012)

---

Minaz Amin (6/11/2009)

---

You need to consider scaling up your processor, RAM, Netwrok Speed, Fast disk subsystem apart from DB load balancing. If number of users increase...

Minaz Amin (6/11/2009)

---

You need to consider scaling up your processor, RAM, Netwrok Speed, Fast disk subsystem apart from DB load balancing. If number of users increase then start thinking for...

Hope you have resolved your issue. You can also refer to "C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\LOG" for detail logs as to your RCA.

durai nagarajan (4/30/2012)

---

another question if i atleast want to block their select and update access is it possible.

can we track DDL, DML statment updation directly on DB with user name...

I have also seen this ty of behavior...

Not such a great solution but I replaced this with a table.I have a job which will basically populate the table and the stored procedure will just read from the...

GSquared (4/23/2012)

---

I'd have to see the reason for the Union All statements (evident from the query, most likely) to be more specific, but if it's all coming from one table...

GilaMonster (4/22/2012)

---

sqldba_newbie (4/22/2012)

---

That's exactly what i thought. So if i have CTP =5 and MAXDOP =1, does it mean that any query who's CTP is more than 5 will use...