please run this query and find all the connections to db...

from the spid you should be able to find the operation by doing sp_who2 <spid>

select d.name, d.dbid, spid, login_time, nt_domain,...

colin.Leversuch-Roberts (9/5/2011)

---

so is your storage san, das or internal?

I can't think of anything offhand which might cause this from a SQL service pack, other than there may (...

thanks!!

thanks again..

thanks!! thanks!!

i couldn't find enough documentation for resource governor online..

thanks for ur help..

In the case of memory, let us say that the Min value set for pool A comes to 2 GB. That is already reserved. The 2 GB will not be...

thanks a lot!!

what happens if the memory requested by operations managed by resource governor exceeds the pool.. will it page out?

can you please explain with this scenario in mind

if the max server...

Got it!!

T2335- trace flag

Thanks...

we have 32 cores..

We have concluded the same

we are planning to apply SP1.

Thanks for the help, I will let you know about the results after applying the service pack.

That's true, we don't use SP's a lot. Most of the queries are ad-hoc.

why i am concerned about this memory is, we see CMEMTHREAD waits only in this server( version...

kind of..

the compiles/sec are almost half of the batches/sec

but as we don't have much load on the system, it is not really affecting.

the end user may see a delay if...

Guys..the sql server restart worked!!

it killed the rollback process and the database was accessible..

just to make sure that I don't run into issues, i took a full backup and verified...

sorry Gila..

i will upload .jpg images, next time.

regarding IO waits, i just see the regular activity in our subsystem.

And as mentioned earlier, our Disk subsystem is pretty good.