How can i measure the non Bpool component??

Note: Its 64 bit server

Plan cache is bpool component post of the times .. Correct? Then it ll be part of 118GB

That's the easiest route . Reducing max server memory . But my concern is is there any memory leak. Apart from 118gb given to bool additional 400mb is used by...

We have few servers in domain and few are working in workgroup.

So, if it is in domain , we use the domain service account.

If it is workgroup, we create...

THis runs like a creame...Awesome veeru

The issue is only on SQL Server 2005. It is not on SQL 2008.

There are 4 tempdb files each 5 GB maxcapped to 10 Gb.

It is a 4...

Paul .

I agree . I will take back my words.

My action item is review the output of drop database command .

Restoring a old master and dropping the DB or rebuild system database is a good option

Buddy

I suspected the same KB and thats why in past i asked you to check the errorlog to see if you have seen any similar to the one which...

there is database corruption. the IO system is robust

yes its supported

this is a acees violation dump. open a case with MS. it is going to be a bug for sure

yes, it is case to case basis but few suggestions

1.Dont alter max worker threads, priority boost and lightweight pooling unless you have come to conclusion that it will improve your...

lock pages in memory

http://blogs.technet.com/askperf/archive/2008/03/25/lock-pages-in-memory-do-you-really-need-it.aspx

In standard they will enable on SP3 CU4

enablle named pipes and TCP/IP at server and check if you are able to connect..

check errorlog and app log to get more details