1

Closed

enable awe memory now nothing

description

I've got SQL Server 2008 (32bit) on Windows 2008R2 and Live Monitor works great on my Win 7 laptop. Now I have enabled awe memory and restarted SQL, but Live Monitor only shows SQL Version and AWE Enabled and everything else is 0. I checked and made sure using SQL 2005 or SQL 2008 native driver. Strange, I can see expensive queries ok

file attachments

Closed Sep 1, 2014 at 10:09 PM by glensmall

comments

fuzzy12 wrote Mar 16, 2013 at 12:10 AM

Here's from the log:

3/15/2013 6:40:47 PM Application Initialised - Version 1.31.4440.19438
3/15/2013 6:41:13 PM Connecting to Database [wswcmdbp] Using SQL Authentication. Detail not shown for security
3/15/2013 6:41:14 PM Server Version is - 10.0.4371.0 - SP2 - Enterprise Edition (64-bit)
3/15/2013 6:41:14 PM Server Has AWE Enabled
3/15/2013 6:41:14 PM Accessing Remote Registry on wswcmdbp
3/15/2013 6:41:14 PM Server Has PAE Disabled
3/15/2013 6:41:14 PM Server Has /3GB Disabled
3/15/2013 6:41:14 PM Running second thread
3/15/2013 6:41:14 PM Adding Performance Counters ......
3/15/2013 6:41:36 PM Pausing thread to update disk counters
3/15/2013 6:41:36 PM Removing old disk counters
3/15/2013 6:41:36 PM Adding new disk counters for dive D:
3/15/2013 6:41:42 PM Resuming
3/15/2013 6:41:45 PM Added 49 Counters in 31030 ms
3/15/2013 6:41:45 PM Entering Loop
3/15/2013 6:41:47 PM EXCEPTION in main loop: Instance '_Total' does not exist in the specified Category.
3/15/2013 6:41:48 PM EXCEPTION in main loop: Instance '_Total' does not exist in the specified Category.
3/15/2013 6:41:49 PM EXCEPTION in main loop: Instance '_Total' does not exist in the specified Category.
3/15/2013 6:41:50 PM EXCEPTION in main loop: Instance '_Total' does not exist in the specified Category.
3/15/2013 6:41:51 PM EXCEPTION in main loop: Instance '_Total' does not exist in the specified Category.
...
3/15/2013 7:06:24 PM Stopping ........
3/15/2013 7:06:25 PM Stopped
3/15/2013 7:06:32 PM Application Closing

glensmall wrote Mar 19, 2013 at 11:19 AM

Sorry I'm confused. Your original report said 32bit SQL, but the log file you just posted says 64bit enterprise edition ??

AWE has no effect on a 64bit system (it's just ignored).

Could you please confirm the versions and the issue please. I will try and repro in my test lab once you confirm the versions for me.

fuzzy12 wrote Mar 19, 2013 at 2:10 PM

Now I'm confused, isn't 10.0 just 32 bit, while 10.50 is 64 bit?

It seems the configuration or something was messed up--I disabled AWE in SQL and rebooted. It is now showing correct memory usage in SQL LM.

glensmall wrote Mar 19, 2013 at 4:20 PM

No. 10.0 is SQL Server 2008. 10.5 is SQL Server 2008 R2

The log you provided states : 3/15/2013 6:41:14 PM Server Version is - 10.0.4371.0 - SP2 - Enterprise Edition (64-bit)

So you have SQL Server 2008 (the original version codename Katmai, rather than SQL 2008 R2 released 18 months later Codename KJ). The version installed is the 64bit enterprise edition, so you don't require AWE.

wrote Sep 1, 2014 at 10:09 PM