Thanks all. The Paging File Usage on Task Manager is indeed badly named. Its the sum of the page file and memory in use. The Counter Page File Usage shows...

Hi Again. I just test AWE extensively and I notice also a lot of page file usage as my buffer_pool_commited_memory_in_GB grew.

My buffer_pool_commited_memory_in_GB grew from about 0.55GB to 7.97GB and my...

Thanks very much people. Just that from some people's posts on the Internet I was beginning to get the impression that I should see this value reflected in the startup.

Fine,...

Hi,

I am using the /PAE switch NOT the /3GB.

The results of the query are below:

physical_memory_in_GB-----------------------------16

VAS_GB------------------------------------------------2

buffer_pool_committed_memory_in_GB-----------1.62

buffer_pool_target_memory_in_GB----------------9.77

Min Server Memory (GB)---------------------------- 0

Max Server Memory (GB)----------------------------9.77

The OS is enterprise edition sp2 and has 16 GB RAM installed and visible to the OS.

Thank you so much Zach.

Thanks so much Zach.

Finally (hopefully :-)), did you use separate disks for your partitions? How bad can putting all your file group on the same disk/spindle be? (due to cost...

Thanks very much Zack.

You mean SWITCH really works that fast? That will be great.

The table I am refering to is mostly used for reporting anyway, we just need to manage...

Hi,

Can I get notification of the latest patches spcifically for SQL Server 205/2008. I subscribed to Microsoft Security Bulletin but most of the information is on the OS.

Thanks

An additional eye-opener for the intended Hardening in our environment.

Thank you. 🙂

Nice article Zach. I think this will work for me. I have a very large table in my production database. The consultant has exonerated himself from any adverse outcome...

Yeah thanks. That makes sense.:-)

Has anyone worked on dealing with the schema changes made by replication (adding a rowguid column).

I am getting loads of errors... any help please:

------------------------------------------------------

The term 'else' is not recognized as the name of a cmdlet, function, script file, or operable program. Check the spelli

ng of...

Hi All,

I also had this error in my environment. I would like to know how it is related to this one (assuming anyone has a quick answer):

A significant part of...