just quickly does the login have the correct default database................

got this right as an educated guess because mirroring is the industry accepted 'easier' to set up, and as the new kid on the block is seen as better.

However as...

SSc (sic)

thanks for the informative post back

cheers

george

haven't tried it but appears to be available here http://www.codeplex.com/MSFTDBProdSamples

post back if it works for you

t.walker (3/6/2009)

---

I really support that idea. I think a more private invited members forum would enable me to speak more freely/

Although I am a rookie here, I am also a...

for this particular long running query its definitely a block, so thanks Gail. It sure helps to be able to bounce things off people when your brain has stopped.

the insert...

Mohit,

the througput is high, also this is a consolidated server, I presume pssdiag can set filters by database as it runs profiler.?

The old pssblocker script produced mountains of output, is...

Jack Corbett (3/5/2009)

---

How is TrackerID created? Is it sequential in nature or can it vary?

I'm just going to guess, and since Gail didn't mention it I may be way...

GilaMonster (3/5/2009)

---

I've never seen profiler reporting false...

backing up master db won't affect no of locks held, though it is something you should be doing on a regular basis!

use sp_lock to see how many locks are taken...

also see http://support.microsoft.com/kb/918483 - it appears lock pages in memory only applicable for enterprise edition

you didn't say what version you had!

sounds like the working set is being trimmed, have you set lock pages in memory for the SQL service account.?

Its more probable the users on server C have become orphaned. run sp_helpuser or select * from sysusers and see if the login column is NULL.

Did you set the logins...

Kris, any other signs of memory pressure.? Can you allocate more memory to SQL in your environment?

Vera, I asked this question a couple of months ago and got very few replies! Having considered it and trawled various resources I have come to the conclusion that I...