RandMan,

I found the microsoft press kits for SQL 2005 certification do a good job of explaining it. I believe it's in the book for the 'first' exam for MCTS:...

Are you using windows authentication and passing through credentials?

If so you have to enable kerberos double-hop by setting a service principal name on both SERVER1 and SERVER2.

There are dozens of...

RBarryYoung (3/27/2009)

---

How are you...

RBarryYoung (3/27/2009)

---

SQLBOT (3/27/2009)

---

Thanks for your response, sir.

Interestingly enough, physical and logical disk utilization...

Thanks for that information, Lowell.

I'm going to file it away.

My question is how does SQL Server 2005 decide when it's had enough of a cached plan and that it needs...

Lowell (3/26/2009)

---

parameter sniffing maybe? have you isolated which proc slowing things down? does it have a default value for any of it's parameters? in my experience, it's the default values...

Thanks for your response, sir.

Interestingly enough, physical and logical disk utilization spikes to...

ALZDBA (3/26/2009)

---

- start a trace to figure out what 's going on.

(you can have the trace start a new file every xMB, and so if the issue didn't occure...

Mike Levan (3/18/2009)

---

we may not need diffrential backups as we do our updates only once a month. and ofcourse we do all our backups with Litespeed.

I still didnt get any...

Sounds like a good job for a differential backup.

I'm curious why you don't want to go that route.

~BOT

best bet:

Create a new table and select into it... measure the new one.

You probably thought of that already and don't have the space.

Another possible way is to measure the average...

Perry Whittle (2/8/2009)

---

Tung

sql2005 standard will address RAM to the operating system max, so no problem there. For a machine with 12GB RAM you may want to remove the /3GB switch...

That's tough to look at.

Next time try capturing a deadlock graph in your trace and it will become more obvious.

Jonathan Kehayias wrote a good article on this just last week...

Took me a minute to overcome the 'owner' and 'request' jargon in the deadlock graph.

To me they're all locks and blocks.

So an 'owner' arrow could by paraphrased as...

Two weeks ago:

http://www.sqlservercentral.com/articles/career+growth/65356/%5B/url%5D