I have configured a SQL200 instance to use 5gb of my server's memory.
At startup the log indicates that AWE is being used, and I see
that the memory is being grabbed when the instance starts.
But in the log indicates that the Working Set Size is set to 1 GB.
Does this mean anything when using AWE..
Am I getting full use of AWE on my instance. How can I tell....
Thanks
Paul
Check the Buffer Manager counter in Perfmon. There are a set of
events/classes related to AWE which you can check.
Anith
Showing posts with label startup. Show all posts
Showing posts with label startup. Show all posts
Friday, 17 February 2012
Configuring SQL to use AWE
I have configured a SQL200 instance to use 5gb of my server's memory.
At startup the log indicates that AWE is being used, and I see
that the memory is being grabbed when the instance starts.
But in the log indicates that the Working Set Size is set to 1 GB.
Does this mean anything when using AWE..
Am I getting full use of AWE on my instance. How can I tell....
Thanks
PaulCheck the Buffer Manager counter in Perfmon. There are a set of
events/classes related to AWE which you can check.
--
Anith
At startup the log indicates that AWE is being used, and I see
that the memory is being grabbed when the instance starts.
But in the log indicates that the Working Set Size is set to 1 GB.
Does this mean anything when using AWE..
Am I getting full use of AWE on my instance. How can I tell....
Thanks
PaulCheck the Buffer Manager counter in Perfmon. There are a set of
events/classes related to AWE which you can check.
--
Anith
Configuring SQL to use AWE
I have configured a SQL200 instance to use 5gb of my server's memory.
At startup the log indicates that AWE is being used, and I see
that the memory is being grabbed when the instance starts.
But in the log indicates that the Working Set Size is set to 1 GB.
Does this mean anything when using AWE..
Am I getting full use of AWE on my instance. How can I tell....
Thanks
PaulCheck the Buffer Manager counter in Perfmon. There are a set of
events/classes related to AWE which you can check.
Anith
At startup the log indicates that AWE is being used, and I see
that the memory is being grabbed when the instance starts.
But in the log indicates that the Working Set Size is set to 1 GB.
Does this mean anything when using AWE..
Am I getting full use of AWE on my instance. How can I tell....
Thanks
PaulCheck the Buffer Manager counter in Perfmon. There are a set of
events/classes related to AWE which you can check.
Anith
Subscribe to:
Posts (Atom)