SQL About AMO: memory

Showing posts with label memory. Show all posts

Saturday, February 25, 2012

About SQL2000 memory usage

This summary is not available. Please click here to view the post.

About SQL2000 memory usage

This summary is not available. Please click here to view the post.

Thursday, February 16, 2012

Hi ,
i have read this KB but this applied also to SQL with AWE enabled for more
then 4 Gbyte ?
http://support.microsoft.com/kb/924054
ThanksHi,
It is a Windows Server bug, regardless which application you launched on
the Server.
Thanks.
Best regards,
Vincent Xu
Microsoft Online Partner Support
======================================================
Get Secure! - www.microsoft.com/security
======================================================When responding to posts, please "Reply to Group" via your newsreader so
that others
may learn and benefit from this issue.
======================================================This posting is provided "AS IS" with no warranties,and confers no rights.
======================================================>>From: <io.com@.newsgroup.nospam>
>>Subject: About ms06-040 memory bug
>>Date: Mon, 21 Aug 2006 22:39:25 +0200
>>Lines: 10
>>X-Priority: 3
>>X-MSMail-Priority: Normal
>>X-Newsreader: Microsoft Outlook Express 6.00.2900.2869
>>X-RFC2646: Format=Flowed; Original
>>X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.2962
>>Message-ID: <exuolHWxGHA.3964@.TK2MSFTNGP04.phx.gbl>
>>Newsgroups: microsoft.public.sqlserver.server
>>NNTP-Posting-Host: 62.241.4.149
>>Path: TK2MSFTNGXA01.phx.gbl!TK2MSFTNGP01.phx.gbl!TK2MSFTNGP04.phx.gbl
>>Xref: TK2MSFTNGXA01.phx.gbl microsoft.public.sqlserver.server:442636
>>X-Tomcat-NG: microsoft.public.sqlserver.server
>>Hi ,
>>i have read this KB but this applied also to SQL with AWE enabled for
more
>>then 4 Gbyte ?
>>http://support.microsoft.com/kb/924054
>>Thanks
>>|||"Vincent Xu [MSFT]" <v-xuwen@.online.microsoft.com> wrote in message
news:pHl$wtZxGHA.1592@.TK2MSFTNGXA01.phx.gbl...
> Hi,
> It is a Windows Server bug, regardless which application you launched on
> the Server.
So is affecting also SQL Server with my configuration ?
Bye !|||Hi,
Glad to hear the information I provided is helpful.
Thanks.
Best regards,
Vincent Xu
Microsoft Online Partner Support
======================================================Get Secure! - www.microsoft.com/security
======================================================When responding to posts, please "Reply to Group" via your newsreader so
that others
may learn and benefit from this issue.
======================================================This posting is provided "AS IS" with no warranties,and confers no rights.
======================================================>>From: <io.com@.newsgroup.nospam>
>>References: <exuolHWxGHA.3964@.TK2MSFTNGP04.phx.gbl>
<pHl$wtZxGHA.1592@.TK2MSFTNGXA01.phx.gbl>
>>Subject: Re: About ms06-040 memory bug
>>Date: Tue, 22 Aug 2006 10:09:13 +0200
>>Lines: 12
>>X-Priority: 3
>>X-MSMail-Priority: Normal
>>X-Newsreader: Microsoft Outlook Express 6.00.2900.2869
>>X-RFC2646: Format=Flowed; Original
>>X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.2962
>>Message-ID: <OglHDJcxGHA.1224@.TK2MSFTNGP03.phx.gbl>
>>Newsgroups: microsoft.public.sqlserver.server
>>NNTP-Posting-Host: 62.241.4.149
>>Path: TK2MSFTNGXA01.phx.gbl!TK2MSFTNGP01.phx.gbl!TK2MSFTNGP03.phx.gbl
>>Xref: TK2MSFTNGXA01.phx.gbl microsoft.public.sqlserver.server:442675
>>X-Tomcat-NG: microsoft.public.sqlserver.server
>>"Vincent Xu [MSFT]" <v-xuwen@.online.microsoft.com> wrote in message
>>news:pHl$wtZxGHA.1592@.TK2MSFTNGXA01.phx.gbl...
>> Hi,
>> It is a Windows Server bug, regardless which application you launched on
>> the Server.
>>So is affecting also SQL Server with my configuration ?
>>Bye !
>>|||Thanks!
"Vincent Xu [MSFT]" <v-xuwen@.online.microsoft.com> wrote in message
news:FoE0V8nxGHA.3392@.TK2MSFTNGXA01.phx.gbl...
> Hi,
> Glad to hear the information I provided is helpful.
> Thanks.
>
> Best regards,
> Vincent Xu
> Microsoft Online Partner Support
> ======================================================> Get Secure! - www.microsoft.com/security
> ======================================================> When responding to posts, please "Reply to Group" via your newsreader so
> that others
> may learn and benefit from this issue.
> ======================================================> This posting is provided "AS IS" with no warranties,and confers no rights.
> ======================================================>
> --
>>From: <io.com@.newsgroup.nospam>
>>References: <exuolHWxGHA.3964@.TK2MSFTNGP04.phx.gbl>
> <pHl$wtZxGHA.1592@.TK2MSFTNGXA01.phx.gbl>
>>Subject: Re: About ms06-040 memory bug
>>Date: Tue, 22 Aug 2006 10:09:13 +0200
>>Lines: 12
>>X-Priority: 3
>>X-MSMail-Priority: Normal
>>X-Newsreader: Microsoft Outlook Express 6.00.2900.2869
>>X-RFC2646: Format=Flowed; Original
>>X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.2962
>>Message-ID: <OglHDJcxGHA.1224@.TK2MSFTNGP03.phx.gbl>
>>Newsgroups: microsoft.public.sqlserver.server
>>NNTP-Posting-Host: 62.241.4.149
>>Path: TK2MSFTNGXA01.phx.gbl!TK2MSFTNGP01.phx.gbl!TK2MSFTNGP03.phx.gbl
>>Xref: TK2MSFTNGXA01.phx.gbl microsoft.public.sqlserver.server:442675
>>X-Tomcat-NG: microsoft.public.sqlserver.server
>>"Vincent Xu [MSFT]" <v-xuwen@.online.microsoft.com> wrote in message
>>news:pHl$wtZxGHA.1592@.TK2MSFTNGXA01.phx.gbl...
>> Hi,
>> It is a Windows Server bug, regardless which application you launched
>> on
>> the Server.
>>So is affecting also SQL Server with my configuration ?
>>Bye !
>>
>|||Vincent,
Has anyone found a solution for this bug. We have been trying partner
support channels but keep getting tranferred to different groups over the
last two weeks and we still have customers that are having the problem. even
with the hotfix applied.
I would appreciate any help you could provide.
"Vincent Xu [MSFT]" wrote:
> Hi,
> Glad to hear the information I provided is helpful.
> Thanks.
>
> Best regards,
> Vincent Xu
> Microsoft Online Partner Support
> ======================================================> Get Secure! - www.microsoft.com/security
> ======================================================> When responding to posts, please "Reply to Group" via your newsreader so
> that others
> may learn and benefit from this issue.
> ======================================================> This posting is provided "AS IS" with no warranties,and confers no rights.
> ======================================================>
> --
> >>From: <io.com@.newsgroup.nospam>
> >>References: <exuolHWxGHA.3964@.TK2MSFTNGP04.phx.gbl>
> <pHl$wtZxGHA.1592@.TK2MSFTNGXA01.phx.gbl>
> >>Subject: Re: About ms06-040 memory bug
> >>Date: Tue, 22 Aug 2006 10:09:13 +0200
> >>Lines: 12
> >>X-Priority: 3
> >>X-MSMail-Priority: Normal
> >>X-Newsreader: Microsoft Outlook Express 6.00.2900.2869
> >>X-RFC2646: Format=Flowed; Original
> >>X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.2962
> >>Message-ID: <OglHDJcxGHA.1224@.TK2MSFTNGP03.phx.gbl>
> >>Newsgroups: microsoft.public.sqlserver.server
> >>NNTP-Posting-Host: 62.241.4.149
> >>Path: TK2MSFTNGXA01.phx.gbl!TK2MSFTNGP01.phx.gbl!TK2MSFTNGP03.phx.gbl
> >>Xref: TK2MSFTNGXA01.phx.gbl microsoft.public.sqlserver.server:442675
> >>X-Tomcat-NG: microsoft.public.sqlserver.server
> >>
> >>"Vincent Xu [MSFT]" <v-xuwen@.online.microsoft.com> wrote in message
> >>news:pHl$wtZxGHA.1592@.TK2MSFTNGXA01.phx.gbl...
> >> Hi,
> >>
> >> It is a Windows Server bug, regardless which application you launched on
> >> the Server.
> >>
> >>So is affecting also SQL Server with my configuration ?
> >>
> >>Bye !
> >>
> >>
> >>
>

About memory amount that SQL Server uses

Is there any function or something like that that returs the amount of MS
SQL Server 2000 memory usage?
Thanks.Take a look into dbcc perfmon command.
Thanks
Hari
SQL Server MVP
"Grcan YCEL" <gurcan@.workmail.com> wrote in message
news:eOwBUw2xGHA.3500@.TK2MSFTNGP02.phx.gbl...
> Is there any function or something like that that returs the amount of MS
> SQL Server 2000 memory usage?
> Thanks.
>|||DBCC MEMORYSTATUS returns the buffer memory allocations (in units of 8kb
pages). This reports the main memory allocations used for data caching &
execution plan caching but there are other memory allocations which you can
collect from the Perfmon's Process(sqlservr) performance counter.. If you
want to translate the buffer counts to Mb, simply multiply them by 8192.0 &
divide by 1048576.0
Regards,
Greg Linwood
SQL Server MVP
"Grcan YCEL" <gurcan@.workmail.com> wrote in message
news:eOwBUw2xGHA.3500@.TK2MSFTNGP02.phx.gbl...
> Is there any function or something like that that returs the amount of MS
> SQL Server 2000 memory usage?
> Thanks.
>

About memory amount that SQL Server uses

Is there any function or something like that that returs the amount of MS
SQL Server 2000 memory usage?
Thanks.Take a look into dbcc perfmon command.
Thanks
Hari
SQL Server MVP
"Gürcan YÜCEL" <gurcan@.workmail.com> wrote in message
news:eOwBUw2xGHA.3500@.TK2MSFTNGP02.phx.gbl...
> Is there any function or something like that that returs the amount of MS
> SQL Server 2000 memory usage?
> Thanks.
>|||DBCC MEMORYSTATUS returns the buffer memory allocations (in units of 8kb
pages). This reports the main memory allocations used for data caching &
execution plan caching but there are other memory allocations which you can
collect from the Perfmon's Process(sqlservr) performance counter.. If you
want to translate the buffer counts to Mb, simply multiply them by 8192.0 &
divide by 1048576.0
Regards,
Greg Linwood
SQL Server MVP
"Gürcan YÜCEL" <gurcan@.workmail.com> wrote in message
news:eOwBUw2xGHA.3500@.TK2MSFTNGP02.phx.gbl...
> Is there any function or something like that that returs the amount of MS
> SQL Server 2000 memory usage?
> Thanks.
>

About memory

Hi I have two question:
1. how to know how much memory that sql server is using in the server?
2 in sql server 64 bit, do I need to setup AWE in order to get more memory?
Thanks.One way is to use
SQLServer:Memory Manager
Total Server Memory (KB)
in Windows Performance monitor.
You do not need to set up AWE in 64-bit environments.
Hope this helps,
Ben Nevarez
"Iter" wrote:
> Hi I have two question:
> 1. how to know how much memory that sql server is using in the server?
> 2 in sql server 64 bit, do I need to setup AWE in order to get more memory?
> Thanks.
>|||Using taskman is very easy but also very misleading on x86 systems using
AWE. A relatively easy way is to use DBCC MEMORYSTATUS & multiply the number
of committed buffers by 8192 then dividing by 1048576 to get the buffer
manager's allocation in Mb. Then, assuming the service hasn't been started
with a -g switch (which alters the SQLServr.exe process's "non buffer
managed" memory allocation or "MTL"), just add a few hundred Mb & you should
be close. This technique is a bit rough but works generically for all
versions & editions of SQL Server.
Regards,
Greg Linwood
SQL Server MVP
http://blogs.sqlserver.org.au/blogs/greg_linwood
Benchmark your query performance
http://www.SQLBenchmarkPro.com
"Iter" <Iter@.discussions.microsoft.com> wrote in message
news:A45E1E8E-8104-446E-B3DF-B05F66D86166@.microsoft.com...
> Hi I have two question:
> 1. how to know how much memory that sql server is using in the server?
> 2 in sql server 64 bit, do I need to setup AWE in order to get more
> memory?
> Thanks.
>

Saturday, February 25, 2012

About SQL2000 memory usage

About SQL2000 memory usage

Thursday, February 16, 2012

About ms06-040 memory bug

About ms06-040 memory bug

About memory amount that SQL Server uses

About memory amount that SQL Server uses

About memory

SQL About AMO

Blog Archive

About Me