We recently enabled AWE on a SQL Server cluster. Each box has 8CPU and 8GB R
AM. The setting seems to have made the difference in RAM usage, but we are e
xperiencing extremely high CPU utilization and overall the system does not s
eem to be any faster. If an
ything, it seems to have slowed down some. There are a lot of variables, but
I was wondering of anyone has had adverse effects with the AWE setting.From BOL.
<<
To enable AWE, set awe enabled to 1. SQL Server will reserve almost all
available memory, leaving 128 megabytes (MB) or less, unless a value has
been specified for max server memory.
What is your max memory setting? Leaving 128M for the OS probably isn't a
good idea.
BTW... Profiler may be helpful in understanding the CPU usage.
Brian Moran
Principal Mentor
Solid Quality Learning
SQL Server MVP
http://www.solidqualitylearning.com
"Phil Appel" <phil@.chileinc.com> wrote in message
news:774F1405-0770-4A4F-B551-9CC330AE9CE4@.microsoft.com...
> We recently enabled AWE on a SQL Server cluster. Each box has 8CPU and 8GB
RAM. The setting seems to have made the difference in RAM usage, but we are
experiencing extremely high CPU utilization and overall the system does not
seem to be any faster. If anything, it seems to have slowed down some. There
are a lot of variables, but I was wondering of anyone has had adverse
effects with the AWE setting.|||We had some CPU spin and server instability issues that were instantaneously
and permenantly solved by turning off the /3GB switch and reducing max
server mem to 1.5GB less than physical. PSS said there was potential kernel
memory starvation with /3GB and max server memory set to near physical. Not
sure if this applies to your scenario.
"Phil Appel" <phil@.chileinc.com> wrote in message
news:774F1405-0770-4A4F-B551-9CC330AE9CE4@.microsoft.com...
> We recently enabled AWE on a SQL Server cluster. Each box has 8CPU and 8GB
RAM. The setting seems to have made the difference in RAM usage, but we are
experiencing extremely high CPU utilization and overall the system does not
seem to be any faster. If anything, it seems to have slowed down some. There
are a lot of variables, but I was wondering of anyone has had adverse
effects with the AWE setting.|||Hi Phil,
I am viewing your post and since we have not heard from you for some time
and I wonder how things go on your side. To disable the AWE to check if the
performance issue is related to the AWE is the method to narrow down
performance problems to AWE. Also, you could refer to the link of the
followings for reference:
How To Gather Information for Effective Troubleshooting of Performance
Issues
http://support.microsoft.com/defaul...microsoft.com:
80/support/kb/articles/Q175/6/58.ASP&NoWebContent=1
http://support.microsoft.com/defaul...kb;en-us;298475
Also, if the case is critical and it should be troubleshot by some advanced
tools which are not supported in the newsgroup. Therefore, we probably will
not be able to resolve the issue through the newsgroups. I'd recommend
opening a Support incident with Microsoft Support Services, so that a
dedicated Support Professional can assist with your advisory case. Please
be advised that contacting phone support will be a charged call.
To obtain the phone numbers for specific technology request please take a
look at the web site listed below.
http://support.microsoft.com/defaul...US;PHONENUMBERS
If you are outside the US please see http://support.microsoft.com for
regional support phone numbers.
Thanks.
Hope this helps.
Best regards
Baisong Wei
Microsoft Online Support
----
Get Secure! - www.microsoft.com/security
This posting is provided "as is" with no warranties and confers no rights.
Please reply to newsgroups only. Thanks.
Showing posts with label usage. Show all posts
Showing posts with label usage. Show all posts
Sunday, March 11, 2012
Saturday, February 25, 2012
AWE - SQL Server 2000 - Memory usage
Hi all!
We have a SQL Server 2000 Enterprise machine with 3.75 GB of ram in it.
Microsoft gave the advise to enable the "AWE" sql server option and the
"/3GB" windows option.
(http://support.microsoft.com/defaul...;274750&sd=tech)
But when I go to the task manager I see SQL server is only using about 144
mb ?
And the total system memory usage is 2.6 GB... and i cannot see the process
that is using that amount of memory.....
-How can I see what it using so much memory?
-Is this a normal situation when you enablee /3GB and AWE or do you see
sqlserver.exe consuming more memory in your task manager?
I want to know if there is something wrong with our configuration.
Thanks in advance for your answer!
Best regards
Floris van HaasterTask Manager isn't AWE aware. Use Perf Mon instead.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/
"Floris van Haaster" <floris@.NO-SPAM-datasmit.nl> wrote in message
news:435de4b3$0$11072$e4fe514c@.news.xs4all.nl...
> Hi all!
> We have a SQL Server 2000 Enterprise machine with 3.75 GB of ram in it.
> Microsoft gave the advise to enable the "AWE" sql server option and the "/
3GB" windows option.
> (http://support.microsoft.com/defaul...;274750&sd=tech)
> But when I go to the task manager I see SQL server is only using about 144
mb ?
> And the total system memory usage is 2.6 GB... and i cannot see the proce
ss that is using that
> amount of memory.....
> -How can I see what it using so much memory?
> -Is this a normal situation when you enablee /3GB and AWE or do you see sq
lserver.exe consuming
> more memory in your task manager?
> I want to know if there is something wrong with our configuration.
> Thanks in advance for your answer!
> Best regards
> Floris van Haaster
>|||Ok thanks,
But what meter shows the correct value?
When i take a look @. "SQLServer:Memory Manager > Maximum Workspace memory
(KB)" it's value = 1175344 KB and that's only 1 GB or so...
Or do i have to look at another counter?
Best regards
Floris
"Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> schreef
in bericht news:%230isnEU2FHA.3228@.TK2MSFTNGP15.phx.gbl...
> Task Manager isn't AWE aware. Use Perf Mon instead.
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
> Blog: http://solidqualitylearning.com/blogs/tibor/
>
> "Floris van Haaster" <floris@.NO-SPAM-datasmit.nl> wrote in message
> news:435de4b3$0$11072$e4fe514c@.news.xs4all.nl...
>|||Use "Buffer Manager: Total Pages" or DBCC MEMORYSTATUS command
(http://support.microsoft.com/?id=271624), check Buffer Counts, Committed,
which should be close to what you are consuming through AWE. Assuming AWE is
enabled.
Later versions (service packs) of SQL Server 2000 also have Visible counter
in DBCC MEMORYSTATUS output which will show how much of AWE-allocated memory
is actually mapped into virtual address space of SQL Server.
HTH,
Boris.
Boris Baryshnikov
Program Manager, SQL Engine
This posting is provided "AS IS" with no warranties, and confers no rights.
"Floris van Haaster" <floris@.NO-SPAM-datasmit.nl> wrote in message
news:435e27bf$0$11063$e4fe514c@.news.xs4all.nl...
> Ok thanks,
> But what meter shows the correct value?
> When i take a look @. "SQLServer:Memory Manager > Maximum Workspace memory
> (KB)" it's value = 1175344 KB and that's only 1 GB or so...
> Or do i have to look at another counter?
> Best regards
> Floris
>
> "Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> schreef
> in bericht news:%230isnEU2FHA.3228@.TK2MSFTNGP15.phx.gbl...
>
We have a SQL Server 2000 Enterprise machine with 3.75 GB of ram in it.
Microsoft gave the advise to enable the "AWE" sql server option and the
"/3GB" windows option.
(http://support.microsoft.com/defaul...;274750&sd=tech)
But when I go to the task manager I see SQL server is only using about 144
mb ?
And the total system memory usage is 2.6 GB... and i cannot see the process
that is using that amount of memory.....
-How can I see what it using so much memory?
-Is this a normal situation when you enablee /3GB and AWE or do you see
sqlserver.exe consuming more memory in your task manager?
I want to know if there is something wrong with our configuration.
Thanks in advance for your answer!
Best regards
Floris van HaasterTask Manager isn't AWE aware. Use Perf Mon instead.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/
"Floris van Haaster" <floris@.NO-SPAM-datasmit.nl> wrote in message
news:435de4b3$0$11072$e4fe514c@.news.xs4all.nl...
> Hi all!
> We have a SQL Server 2000 Enterprise machine with 3.75 GB of ram in it.
> Microsoft gave the advise to enable the "AWE" sql server option and the "/
3GB" windows option.
> (http://support.microsoft.com/defaul...;274750&sd=tech)
> But when I go to the task manager I see SQL server is only using about 144
mb ?
> And the total system memory usage is 2.6 GB... and i cannot see the proce
ss that is using that
> amount of memory.....
> -How can I see what it using so much memory?
> -Is this a normal situation when you enablee /3GB and AWE or do you see sq
lserver.exe consuming
> more memory in your task manager?
> I want to know if there is something wrong with our configuration.
> Thanks in advance for your answer!
> Best regards
> Floris van Haaster
>|||Ok thanks,
But what meter shows the correct value?
When i take a look @. "SQLServer:Memory Manager > Maximum Workspace memory
(KB)" it's value = 1175344 KB and that's only 1 GB or so...
Or do i have to look at another counter?
Best regards
Floris
"Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> schreef
in bericht news:%230isnEU2FHA.3228@.TK2MSFTNGP15.phx.gbl...
> Task Manager isn't AWE aware. Use Perf Mon instead.
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
> Blog: http://solidqualitylearning.com/blogs/tibor/
>
> "Floris van Haaster" <floris@.NO-SPAM-datasmit.nl> wrote in message
> news:435de4b3$0$11072$e4fe514c@.news.xs4all.nl...
>|||Use "Buffer Manager: Total Pages" or DBCC MEMORYSTATUS command
(http://support.microsoft.com/?id=271624), check Buffer Counts, Committed,
which should be close to what you are consuming through AWE. Assuming AWE is
enabled.
Later versions (service packs) of SQL Server 2000 also have Visible counter
in DBCC MEMORYSTATUS output which will show how much of AWE-allocated memory
is actually mapped into virtual address space of SQL Server.
HTH,
Boris.
Boris Baryshnikov
Program Manager, SQL Engine
This posting is provided "AS IS" with no warranties, and confers no rights.
"Floris van Haaster" <floris@.NO-SPAM-datasmit.nl> wrote in message
news:435e27bf$0$11063$e4fe514c@.news.xs4all.nl...
> Ok thanks,
> But what meter shows the correct value?
> When i take a look @. "SQLServer:Memory Manager > Maximum Workspace memory
> (KB)" it's value = 1175344 KB and that's only 1 GB or so...
> Or do i have to look at another counter?
> Best regards
> Floris
>
> "Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> schreef
> in bericht news:%230isnEU2FHA.3228@.TK2MSFTNGP15.phx.gbl...
>
AWE - SQL Server 2000 - Memory usage
Hi all!
We have a SQL Server 2000 Enterprise machine with 3.75 GB of ram in it.
Microsoft gave the advise to enable the "AWE" sql server option and the
"/3GB" windows option.
(http://support.microsoft.com/default...274750&sd=tech)
But when I go to the task manager I see SQL server is only using about 144
mb ?
And the total system memory usage is 2.6 GB... and i cannot see the process
that is using that amount of memory.....
-How can I see what it using so much memory?
-Is this a normal situation when you enablee /3GB and AWE or do you see
sqlserver.exe consuming more memory in your task manager?
I want to know if there is something wrong with our configuration.
Thanks in advance for your answer!
Best regards
Floris van Haaster
Task Manager isn't AWE aware. Use Perf Mon instead.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/
"Floris van Haaster" <floris@.NO-SPAM-datasmit.nl> wrote in message
news:435de4b3$0$11072$e4fe514c@.news.xs4all.nl...
> Hi all!
> We have a SQL Server 2000 Enterprise machine with 3.75 GB of ram in it.
> Microsoft gave the advise to enable the "AWE" sql server option and the "/3GB" windows option.
> (http://support.microsoft.com/default...274750&sd=tech)
> But when I go to the task manager I see SQL server is only using about 144 mb ?
> And the total system memory usage is 2.6 GB... and i cannot see the process that is using that
> amount of memory.....
> -How can I see what it using so much memory?
> -Is this a normal situation when you enablee /3GB and AWE or do you see sqlserver.exe consuming
> more memory in your task manager?
> I want to know if there is something wrong with our configuration.
> Thanks in advance for your answer!
> Best regards
> Floris van Haaster
>
|||Ok thanks,
But what meter shows the correct value?
When i take a look @. "SQLServer:Memory Manager > Maximum Workspace memory
(KB)" it's value = 1175344 KB and that's only 1 GB or so...
Or do i have to look at another counter?
Best regards
Floris
"Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> schreef
in bericht news:%230isnEU2FHA.3228@.TK2MSFTNGP15.phx.gbl...
> Task Manager isn't AWE aware. Use Perf Mon instead.
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
> Blog: http://solidqualitylearning.com/blogs/tibor/
>
> "Floris van Haaster" <floris@.NO-SPAM-datasmit.nl> wrote in message
> news:435de4b3$0$11072$e4fe514c@.news.xs4all.nl...
>
|||Use "Buffer Manager: Total Pages" or DBCC MEMORYSTATUS command
(http://support.microsoft.com/?id=271624), check Buffer Counts, Committed,
which should be close to what you are consuming through AWE. Assuming AWE is
enabled.
Later versions (service packs) of SQL Server 2000 also have Visible counter
in DBCC MEMORYSTATUS output which will show how much of AWE-allocated memory
is actually mapped into virtual address space of SQL Server.
HTH,
Boris.
Boris Baryshnikov
Program Manager, SQL Engine
This posting is provided "AS IS" with no warranties, and confers no rights.
"Floris van Haaster" <floris@.NO-SPAM-datasmit.nl> wrote in message
news:435e27bf$0$11063$e4fe514c@.news.xs4all.nl...
> Ok thanks,
> But what meter shows the correct value?
> When i take a look @. "SQLServer:Memory Manager > Maximum Workspace memory
> (KB)" it's value = 1175344 KB and that's only 1 GB or so...
> Or do i have to look at another counter?
> Best regards
> Floris
>
> "Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> schreef
> in bericht news:%230isnEU2FHA.3228@.TK2MSFTNGP15.phx.gbl...
>
We have a SQL Server 2000 Enterprise machine with 3.75 GB of ram in it.
Microsoft gave the advise to enable the "AWE" sql server option and the
"/3GB" windows option.
(http://support.microsoft.com/default...274750&sd=tech)
But when I go to the task manager I see SQL server is only using about 144
mb ?
And the total system memory usage is 2.6 GB... and i cannot see the process
that is using that amount of memory.....
-How can I see what it using so much memory?
-Is this a normal situation when you enablee /3GB and AWE or do you see
sqlserver.exe consuming more memory in your task manager?
I want to know if there is something wrong with our configuration.
Thanks in advance for your answer!
Best regards
Floris van Haaster
Task Manager isn't AWE aware. Use Perf Mon instead.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/
"Floris van Haaster" <floris@.NO-SPAM-datasmit.nl> wrote in message
news:435de4b3$0$11072$e4fe514c@.news.xs4all.nl...
> Hi all!
> We have a SQL Server 2000 Enterprise machine with 3.75 GB of ram in it.
> Microsoft gave the advise to enable the "AWE" sql server option and the "/3GB" windows option.
> (http://support.microsoft.com/default...274750&sd=tech)
> But when I go to the task manager I see SQL server is only using about 144 mb ?
> And the total system memory usage is 2.6 GB... and i cannot see the process that is using that
> amount of memory.....
> -How can I see what it using so much memory?
> -Is this a normal situation when you enablee /3GB and AWE or do you see sqlserver.exe consuming
> more memory in your task manager?
> I want to know if there is something wrong with our configuration.
> Thanks in advance for your answer!
> Best regards
> Floris van Haaster
>
|||Ok thanks,
But what meter shows the correct value?
When i take a look @. "SQLServer:Memory Manager > Maximum Workspace memory
(KB)" it's value = 1175344 KB and that's only 1 GB or so...
Or do i have to look at another counter?
Best regards
Floris
"Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> schreef
in bericht news:%230isnEU2FHA.3228@.TK2MSFTNGP15.phx.gbl...
> Task Manager isn't AWE aware. Use Perf Mon instead.
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
> Blog: http://solidqualitylearning.com/blogs/tibor/
>
> "Floris van Haaster" <floris@.NO-SPAM-datasmit.nl> wrote in message
> news:435de4b3$0$11072$e4fe514c@.news.xs4all.nl...
>
|||Use "Buffer Manager: Total Pages" or DBCC MEMORYSTATUS command
(http://support.microsoft.com/?id=271624), check Buffer Counts, Committed,
which should be close to what you are consuming through AWE. Assuming AWE is
enabled.
Later versions (service packs) of SQL Server 2000 also have Visible counter
in DBCC MEMORYSTATUS output which will show how much of AWE-allocated memory
is actually mapped into virtual address space of SQL Server.
HTH,
Boris.
Boris Baryshnikov
Program Manager, SQL Engine
This posting is provided "AS IS" with no warranties, and confers no rights.
"Floris van Haaster" <floris@.NO-SPAM-datasmit.nl> wrote in message
news:435e27bf$0$11063$e4fe514c@.news.xs4all.nl...
> Ok thanks,
> But what meter shows the correct value?
> When i take a look @. "SQLServer:Memory Manager > Maximum Workspace memory
> (KB)" it's value = 1175344 KB and that's only 1 GB or so...
> Or do i have to look at another counter?
> Best regards
> Floris
>
> "Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> schreef
> in bericht news:%230isnEU2FHA.3228@.TK2MSFTNGP15.phx.gbl...
>
AWE - SQL Server 2000 - Memory usage
Hi all!
We have a SQL Server 2000 Enterprise machine with 3.75 GB of ram in it.
Microsoft gave the advise to enable the "AWE" sql server option and the
"/3GB" windows option.
(http://support.microsoft.com/default.aspx?scid=kb;en-us;274750&sd=tech)
But when I go to the task manager I see SQL server is only using about 144
mb ?
And the total system memory usage is 2.6 GB... and i cannot see the process
that is using that amount of memory.....
-How can I see what it using so much memory?
-Is this a normal situation when you enablee /3GB and AWE or do you see
sqlserver.exe consuming more memory in your task manager?
I want to know if there is something wrong with our configuration.
Thanks in advance for your answer!
Best regards
Floris van HaasterTask Manager isn't AWE aware. Use Perf Mon instead.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/
"Floris van Haaster" <floris@.NO-SPAM-datasmit.nl> wrote in message
news:435de4b3$0$11072$e4fe514c@.news.xs4all.nl...
> Hi all!
> We have a SQL Server 2000 Enterprise machine with 3.75 GB of ram in it.
> Microsoft gave the advise to enable the "AWE" sql server option and the "/3GB" windows option.
> (http://support.microsoft.com/default.aspx?scid=kb;en-us;274750&sd=tech)
> But when I go to the task manager I see SQL server is only using about 144 mb ?
> And the total system memory usage is 2.6 GB... and i cannot see the process that is using that
> amount of memory.....
> -How can I see what it using so much memory?
> -Is this a normal situation when you enablee /3GB and AWE or do you see sqlserver.exe consuming
> more memory in your task manager?
> I want to know if there is something wrong with our configuration.
> Thanks in advance for your answer!
> Best regards
> Floris van Haaster
>|||Ok thanks,
But what meter shows the correct value?
When i take a look @. "SQLServer:Memory Manager > Maximum Workspace memory
(KB)" it's value = 1175344 KB and that's only 1 GB or so...
Or do i have to look at another counter?
Best regards
Floris
"Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> schreef
in bericht news:%230isnEU2FHA.3228@.TK2MSFTNGP15.phx.gbl...
> Task Manager isn't AWE aware. Use Perf Mon instead.
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
> Blog: http://solidqualitylearning.com/blogs/tibor/
>
> "Floris van Haaster" <floris@.NO-SPAM-datasmit.nl> wrote in message
> news:435de4b3$0$11072$e4fe514c@.news.xs4all.nl...
>> Hi all!
>> We have a SQL Server 2000 Enterprise machine with 3.75 GB of ram in it.
>> Microsoft gave the advise to enable the "AWE" sql server option and the
>> "/3GB" windows option.
>> (http://support.microsoft.com/default.aspx?scid=kb;en-us;274750&sd=tech)
>> But when I go to the task manager I see SQL server is only using about
>> 144 mb ?
>> And the total system memory usage is 2.6 GB... and i cannot see the
>> process that is using that amount of memory.....
>> -How can I see what it using so much memory?
>> -Is this a normal situation when you enablee /3GB and AWE or do you see
>> sqlserver.exe consuming more memory in your task manager?
>> I want to know if there is something wrong with our configuration.
>> Thanks in advance for your answer!
>> Best regards
>> Floris van Haaster
>>
>|||Use "Buffer Manager: Total Pages" or DBCC MEMORYSTATUS command
(http://support.microsoft.com/?id=271624), check Buffer Counts, Committed,
which should be close to what you are consuming through AWE. Assuming AWE is
enabled.
Later versions (service packs) of SQL Server 2000 also have Visible counter
in DBCC MEMORYSTATUS output which will show how much of AWE-allocated memory
is actually mapped into virtual address space of SQL Server.
HTH,
Boris.
Boris Baryshnikov
Program Manager, SQL Engine
This posting is provided "AS IS" with no warranties, and confers no rights.
"Floris van Haaster" <floris@.NO-SPAM-datasmit.nl> wrote in message
news:435e27bf$0$11063$e4fe514c@.news.xs4all.nl...
> Ok thanks,
> But what meter shows the correct value?
> When i take a look @. "SQLServer:Memory Manager > Maximum Workspace memory
> (KB)" it's value = 1175344 KB and that's only 1 GB or so...
> Or do i have to look at another counter?
> Best regards
> Floris
>
> "Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> schreef
> in bericht news:%230isnEU2FHA.3228@.TK2MSFTNGP15.phx.gbl...
>> Task Manager isn't AWE aware. Use Perf Mon instead.
>> --
>> Tibor Karaszi, SQL Server MVP
>> http://www.karaszi.com/sqlserver/default.asp
>> http://www.solidqualitylearning.com/
>> Blog: http://solidqualitylearning.com/blogs/tibor/
>>
>> "Floris van Haaster" <floris@.NO-SPAM-datasmit.nl> wrote in message
>> news:435de4b3$0$11072$e4fe514c@.news.xs4all.nl...
>> Hi all!
>> We have a SQL Server 2000 Enterprise machine with 3.75 GB of ram in it.
>> Microsoft gave the advise to enable the "AWE" sql server option and the
>> "/3GB" windows option.
>> (http://support.microsoft.com/default.aspx?scid=kb;en-us;274750&sd=tech)
>> But when I go to the task manager I see SQL server is only using about
>> 144 mb ?
>> And the total system memory usage is 2.6 GB... and i cannot see the
>> process that is using that amount of memory.....
>> -How can I see what it using so much memory?
>> -Is this a normal situation when you enablee /3GB and AWE or do you see
>> sqlserver.exe consuming more memory in your task manager?
>> I want to know if there is something wrong with our configuration.
>> Thanks in advance for your answer!
>> Best regards
>> Floris van Haaster
>>
>
We have a SQL Server 2000 Enterprise machine with 3.75 GB of ram in it.
Microsoft gave the advise to enable the "AWE" sql server option and the
"/3GB" windows option.
(http://support.microsoft.com/default.aspx?scid=kb;en-us;274750&sd=tech)
But when I go to the task manager I see SQL server is only using about 144
mb ?
And the total system memory usage is 2.6 GB... and i cannot see the process
that is using that amount of memory.....
-How can I see what it using so much memory?
-Is this a normal situation when you enablee /3GB and AWE or do you see
sqlserver.exe consuming more memory in your task manager?
I want to know if there is something wrong with our configuration.
Thanks in advance for your answer!
Best regards
Floris van HaasterTask Manager isn't AWE aware. Use Perf Mon instead.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/
"Floris van Haaster" <floris@.NO-SPAM-datasmit.nl> wrote in message
news:435de4b3$0$11072$e4fe514c@.news.xs4all.nl...
> Hi all!
> We have a SQL Server 2000 Enterprise machine with 3.75 GB of ram in it.
> Microsoft gave the advise to enable the "AWE" sql server option and the "/3GB" windows option.
> (http://support.microsoft.com/default.aspx?scid=kb;en-us;274750&sd=tech)
> But when I go to the task manager I see SQL server is only using about 144 mb ?
> And the total system memory usage is 2.6 GB... and i cannot see the process that is using that
> amount of memory.....
> -How can I see what it using so much memory?
> -Is this a normal situation when you enablee /3GB and AWE or do you see sqlserver.exe consuming
> more memory in your task manager?
> I want to know if there is something wrong with our configuration.
> Thanks in advance for your answer!
> Best regards
> Floris van Haaster
>|||Ok thanks,
But what meter shows the correct value?
When i take a look @. "SQLServer:Memory Manager > Maximum Workspace memory
(KB)" it's value = 1175344 KB and that's only 1 GB or so...
Or do i have to look at another counter?
Best regards
Floris
"Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> schreef
in bericht news:%230isnEU2FHA.3228@.TK2MSFTNGP15.phx.gbl...
> Task Manager isn't AWE aware. Use Perf Mon instead.
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
> Blog: http://solidqualitylearning.com/blogs/tibor/
>
> "Floris van Haaster" <floris@.NO-SPAM-datasmit.nl> wrote in message
> news:435de4b3$0$11072$e4fe514c@.news.xs4all.nl...
>> Hi all!
>> We have a SQL Server 2000 Enterprise machine with 3.75 GB of ram in it.
>> Microsoft gave the advise to enable the "AWE" sql server option and the
>> "/3GB" windows option.
>> (http://support.microsoft.com/default.aspx?scid=kb;en-us;274750&sd=tech)
>> But when I go to the task manager I see SQL server is only using about
>> 144 mb ?
>> And the total system memory usage is 2.6 GB... and i cannot see the
>> process that is using that amount of memory.....
>> -How can I see what it using so much memory?
>> -Is this a normal situation when you enablee /3GB and AWE or do you see
>> sqlserver.exe consuming more memory in your task manager?
>> I want to know if there is something wrong with our configuration.
>> Thanks in advance for your answer!
>> Best regards
>> Floris van Haaster
>>
>|||Use "Buffer Manager: Total Pages" or DBCC MEMORYSTATUS command
(http://support.microsoft.com/?id=271624), check Buffer Counts, Committed,
which should be close to what you are consuming through AWE. Assuming AWE is
enabled.
Later versions (service packs) of SQL Server 2000 also have Visible counter
in DBCC MEMORYSTATUS output which will show how much of AWE-allocated memory
is actually mapped into virtual address space of SQL Server.
HTH,
Boris.
Boris Baryshnikov
Program Manager, SQL Engine
This posting is provided "AS IS" with no warranties, and confers no rights.
"Floris van Haaster" <floris@.NO-SPAM-datasmit.nl> wrote in message
news:435e27bf$0$11063$e4fe514c@.news.xs4all.nl...
> Ok thanks,
> But what meter shows the correct value?
> When i take a look @. "SQLServer:Memory Manager > Maximum Workspace memory
> (KB)" it's value = 1175344 KB and that's only 1 GB or so...
> Or do i have to look at another counter?
> Best regards
> Floris
>
> "Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> schreef
> in bericht news:%230isnEU2FHA.3228@.TK2MSFTNGP15.phx.gbl...
>> Task Manager isn't AWE aware. Use Perf Mon instead.
>> --
>> Tibor Karaszi, SQL Server MVP
>> http://www.karaszi.com/sqlserver/default.asp
>> http://www.solidqualitylearning.com/
>> Blog: http://solidqualitylearning.com/blogs/tibor/
>>
>> "Floris van Haaster" <floris@.NO-SPAM-datasmit.nl> wrote in message
>> news:435de4b3$0$11072$e4fe514c@.news.xs4all.nl...
>> Hi all!
>> We have a SQL Server 2000 Enterprise machine with 3.75 GB of ram in it.
>> Microsoft gave the advise to enable the "AWE" sql server option and the
>> "/3GB" windows option.
>> (http://support.microsoft.com/default.aspx?scid=kb;en-us;274750&sd=tech)
>> But when I go to the task manager I see SQL server is only using about
>> 144 mb ?
>> And the total system memory usage is 2.6 GB... and i cannot see the
>> process that is using that amount of memory.....
>> -How can I see what it using so much memory?
>> -Is this a normal situation when you enablee /3GB and AWE or do you see
>> sqlserver.exe consuming more memory in your task manager?
>> I want to know if there is something wrong with our configuration.
>> Thanks in advance for your answer!
>> Best regards
>> Floris van Haaster
>>
>
Avoiding the usage of DTC
Hello
I am running an script and the following sentence throws and error because the DTC service is not running in the Remote Server:
insert into MyLocalTable
execute synonym_MyRemoteProcedure @.SomeParameter
Since a transaction is not declared within the script, why is the DTC required?
How can I avoid the usage of the DTC? Is there a way to say "this code is not within a distributed transaction"?
Thanks a lot.You are still in an explicit transaction. As far as I know, the requirement that the DTC service be running can not be bypassed. You can try using just a select statement to get the data from the remote server, as the "black box" nature of the stored procedure may be causing this.
I am running an script and the following sentence throws and error because the DTC service is not running in the Remote Server:
insert into MyLocalTable
execute synonym_MyRemoteProcedure @.SomeParameter
Since a transaction is not declared within the script, why is the DTC required?
How can I avoid the usage of the DTC? Is there a way to say "this code is not within a distributed transaction"?
Thanks a lot.You are still in an explicit transaction. As far as I know, the requirement that the DTC service be running can not be bypassed. You can try using just a select statement to get the data from the remote server, as the "black box" nature of the stored procedure may be causing this.
Subscribe to:
Posts (Atom)