Where can I get a definition of what the Performance Monitor counter
relating to AWE memory mean? Also, what are normal ranges for these
counters, what would be considered "high"
The counters I'm referring to are:
SQLServer:Buffer Manager\AWE lookup maps/sec
SQLServer:Buffer Manager\AWE stolen maps/sec
SQLServer:Buffer Manager\AWE stolen maps/sec
SQLServer:Buffer Manager\AWE unmap calls/sec
SQLServer:Buffer Manager\AWE unmap pages/sec
SQLServer:Buffer Manager\AWE write maps/sec
Any input is appreciated.The definition can be found at
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/adminsql/ad_perfmon_0ugk.asp.
--
Dejan Sarka, SQL Server MVP
Please reply only to the newsgroups.
"Ed Thibert" <ethibert@.dlbabson.com> wrote in message
news:OdUd0D4rDHA.732@.TK2MSFTNGP09.phx.gbl...
> Where can I get a definition of what the Performance Monitor counter
> relating to AWE memory mean? Also, what are normal ranges for these
> counters, what would be considered "high"
> The counters I'm referring to are:
> SQLServer:Buffer Manager\AWE lookup maps/sec
> SQLServer:Buffer Manager\AWE stolen maps/sec
> SQLServer:Buffer Manager\AWE stolen maps/sec
> SQLServer:Buffer Manager\AWE unmap calls/sec
> SQLServer:Buffer Manager\AWE unmap pages/sec
> SQLServer:Buffer Manager\AWE write maps/sec
>
> Any input is appreciated.
>
Showing posts with label monitor. Show all posts
Showing posts with label monitor. Show all posts
Thursday, March 8, 2012
AWE Memory
I am finding conflicting opinions on how to monitor memory bottlenecks on AWE
enabled systems. Can anyone provide any meaningfull info? I am aware of all
the related performance counters. Howeve,r I do not know which one are still
usefull once AWE is enabled. Also what are the accepable values for the AWE
counters?
Oscar Elleseff
The PageLifeExpentancy and CacheHitRatio counters are still very valid and
most useful for determining if you have memory pressure.
Andrew J. Kelly SQL MVP
"Oscar" <Oscar@.discussions.microsoft.com> wrote in message
news:5B77575A-EE3C-41E5-8971-7436ADD59C37@.microsoft.com...
>I am finding conflicting opinions on how to monitor memory bottlenecks on
>AWE
> enabled systems. Can anyone provide any meaningfull info? I am aware of
> all
> the related performance counters. Howeve,r I do not know which one are
> still
> usefull once AWE is enabled. Also what are the accepable values for the
> AWE
> counters?
> Oscar Elleseff
|||Thank You Andrew,
What about AWE specific counters? How can they be used to evaluate memory
pressure? For example, does 'AWE lookup/maps sec' have any applications in
this case and if it does what are the values we should be looking for?
Oscar Elleseff
"Andrew J. Kelly" wrote:
> The PageLifeExpentancy and CacheHitRatio counters are still very valid and
> most useful for determining if you have memory pressure.
> --
> Andrew J. Kelly SQL MVP
>
> "Oscar" <Oscar@.discussions.microsoft.com> wrote in message
> news:5B77575A-EE3C-41E5-8971-7436ADD59C37@.microsoft.com...
>
>
|||If there is memory pressure in AWE or physical memory it will show up in the
counters mentioned. The AWE specific counters may be useful for some very
specific troubleshooting but you will see memory pressure first in the PLF &
CacheHit Ratio counters.
Andrew J. Kelly SQL MVP
"Oscar" <Oscar@.discussions.microsoft.com> wrote in message
news:C1B1A04D-ED6E-4306-8510-5D51D4E959A2@.microsoft.com...[vbcol=seagreen]
> Thank You Andrew,
> What about AWE specific counters? How can they be used to evaluate memory
> pressure? For example, does 'AWE lookup/maps sec' have any applications
> in
> this case and if it does what are the values we should be looking for?
> Oscar Elleseff
> "Andrew J. Kelly" wrote:
enabled systems. Can anyone provide any meaningfull info? I am aware of all
the related performance counters. Howeve,r I do not know which one are still
usefull once AWE is enabled. Also what are the accepable values for the AWE
counters?
Oscar Elleseff
The PageLifeExpentancy and CacheHitRatio counters are still very valid and
most useful for determining if you have memory pressure.
Andrew J. Kelly SQL MVP
"Oscar" <Oscar@.discussions.microsoft.com> wrote in message
news:5B77575A-EE3C-41E5-8971-7436ADD59C37@.microsoft.com...
>I am finding conflicting opinions on how to monitor memory bottlenecks on
>AWE
> enabled systems. Can anyone provide any meaningfull info? I am aware of
> all
> the related performance counters. Howeve,r I do not know which one are
> still
> usefull once AWE is enabled. Also what are the accepable values for the
> AWE
> counters?
> Oscar Elleseff
|||Thank You Andrew,
What about AWE specific counters? How can they be used to evaluate memory
pressure? For example, does 'AWE lookup/maps sec' have any applications in
this case and if it does what are the values we should be looking for?
Oscar Elleseff
"Andrew J. Kelly" wrote:
> The PageLifeExpentancy and CacheHitRatio counters are still very valid and
> most useful for determining if you have memory pressure.
> --
> Andrew J. Kelly SQL MVP
>
> "Oscar" <Oscar@.discussions.microsoft.com> wrote in message
> news:5B77575A-EE3C-41E5-8971-7436ADD59C37@.microsoft.com...
>
>
|||If there is memory pressure in AWE or physical memory it will show up in the
counters mentioned. The AWE specific counters may be useful for some very
specific troubleshooting but you will see memory pressure first in the PLF &
CacheHit Ratio counters.
Andrew J. Kelly SQL MVP
"Oscar" <Oscar@.discussions.microsoft.com> wrote in message
news:C1B1A04D-ED6E-4306-8510-5D51D4E959A2@.microsoft.com...[vbcol=seagreen]
> Thank You Andrew,
> What about AWE specific counters? How can they be used to evaluate memory
> pressure? For example, does 'AWE lookup/maps sec' have any applications
> in
> this case and if it does what are the values we should be looking for?
> Oscar Elleseff
> "Andrew J. Kelly" wrote:
AWE Memory
I am finding conflicting opinions on how to monitor memory bottlenecks on AWE
enabled systems. Can anyone provide any meaningfull info? I am aware of all
the related performance counters. Howeve,r I do not know which one are still
usefull once AWE is enabled. Also what are the accepable values for the AWE
counters?
Oscar ElleseffThe PageLifeExpentancy and CacheHitRatio counters are still very valid and
most useful for determining if you have memory pressure.
--
Andrew J. Kelly SQL MVP
"Oscar" <Oscar@.discussions.microsoft.com> wrote in message
news:5B77575A-EE3C-41E5-8971-7436ADD59C37@.microsoft.com...
>I am finding conflicting opinions on how to monitor memory bottlenecks on
>AWE
> enabled systems. Can anyone provide any meaningfull info? I am aware of
> all
> the related performance counters. Howeve,r I do not know which one are
> still
> usefull once AWE is enabled. Also what are the accepable values for the
> AWE
> counters?
> Oscar Elleseff|||Thank You Andrew,
What about AWE specific counters? How can they be used to evaluate memory
pressure? For example, does 'AWE lookup/maps sec' have any applications in
this case and if it does what are the values we should be looking for?
Oscar Elleseff
"Andrew J. Kelly" wrote:
> The PageLifeExpentancy and CacheHitRatio counters are still very valid and
> most useful for determining if you have memory pressure.
> --
> Andrew J. Kelly SQL MVP
>
> "Oscar" <Oscar@.discussions.microsoft.com> wrote in message
> news:5B77575A-EE3C-41E5-8971-7436ADD59C37@.microsoft.com...
> >I am finding conflicting opinions on how to monitor memory bottlenecks on
> >AWE
> > enabled systems. Can anyone provide any meaningfull info? I am aware of
> > all
> > the related performance counters. Howeve,r I do not know which one are
> > still
> > usefull once AWE is enabled. Also what are the accepable values for the
> > AWE
> > counters?
> >
> > Oscar Elleseff
>
>|||If there is memory pressure in AWE or physical memory it will show up in the
counters mentioned. The AWE specific counters may be useful for some very
specific troubleshooting but you will see memory pressure first in the PLF &
CacheHit Ratio counters.
--
Andrew J. Kelly SQL MVP
"Oscar" <Oscar@.discussions.microsoft.com> wrote in message
news:C1B1A04D-ED6E-4306-8510-5D51D4E959A2@.microsoft.com...
> Thank You Andrew,
> What about AWE specific counters? How can they be used to evaluate memory
> pressure? For example, does 'AWE lookup/maps sec' have any applications
> in
> this case and if it does what are the values we should be looking for?
> Oscar Elleseff
> "Andrew J. Kelly" wrote:
>> The PageLifeExpentancy and CacheHitRatio counters are still very valid
>> and
>> most useful for determining if you have memory pressure.
>> --
>> Andrew J. Kelly SQL MVP
>>
>> "Oscar" <Oscar@.discussions.microsoft.com> wrote in message
>> news:5B77575A-EE3C-41E5-8971-7436ADD59C37@.microsoft.com...
>> >I am finding conflicting opinions on how to monitor memory bottlenecks
>> >on
>> >AWE
>> > enabled systems. Can anyone provide any meaningfull info? I am aware
>> > of
>> > all
>> > the related performance counters. Howeve,r I do not know which one are
>> > still
>> > usefull once AWE is enabled. Also what are the accepable values for
>> > the
>> > AWE
>> > counters?
>> >
>> > Oscar Elleseff
>>
enabled systems. Can anyone provide any meaningfull info? I am aware of all
the related performance counters. Howeve,r I do not know which one are still
usefull once AWE is enabled. Also what are the accepable values for the AWE
counters?
Oscar ElleseffThe PageLifeExpentancy and CacheHitRatio counters are still very valid and
most useful for determining if you have memory pressure.
--
Andrew J. Kelly SQL MVP
"Oscar" <Oscar@.discussions.microsoft.com> wrote in message
news:5B77575A-EE3C-41E5-8971-7436ADD59C37@.microsoft.com...
>I am finding conflicting opinions on how to monitor memory bottlenecks on
>AWE
> enabled systems. Can anyone provide any meaningfull info? I am aware of
> all
> the related performance counters. Howeve,r I do not know which one are
> still
> usefull once AWE is enabled. Also what are the accepable values for the
> AWE
> counters?
> Oscar Elleseff|||Thank You Andrew,
What about AWE specific counters? How can they be used to evaluate memory
pressure? For example, does 'AWE lookup/maps sec' have any applications in
this case and if it does what are the values we should be looking for?
Oscar Elleseff
"Andrew J. Kelly" wrote:
> The PageLifeExpentancy and CacheHitRatio counters are still very valid and
> most useful for determining if you have memory pressure.
> --
> Andrew J. Kelly SQL MVP
>
> "Oscar" <Oscar@.discussions.microsoft.com> wrote in message
> news:5B77575A-EE3C-41E5-8971-7436ADD59C37@.microsoft.com...
> >I am finding conflicting opinions on how to monitor memory bottlenecks on
> >AWE
> > enabled systems. Can anyone provide any meaningfull info? I am aware of
> > all
> > the related performance counters. Howeve,r I do not know which one are
> > still
> > usefull once AWE is enabled. Also what are the accepable values for the
> > AWE
> > counters?
> >
> > Oscar Elleseff
>
>|||If there is memory pressure in AWE or physical memory it will show up in the
counters mentioned. The AWE specific counters may be useful for some very
specific troubleshooting but you will see memory pressure first in the PLF &
CacheHit Ratio counters.
--
Andrew J. Kelly SQL MVP
"Oscar" <Oscar@.discussions.microsoft.com> wrote in message
news:C1B1A04D-ED6E-4306-8510-5D51D4E959A2@.microsoft.com...
> Thank You Andrew,
> What about AWE specific counters? How can they be used to evaluate memory
> pressure? For example, does 'AWE lookup/maps sec' have any applications
> in
> this case and if it does what are the values we should be looking for?
> Oscar Elleseff
> "Andrew J. Kelly" wrote:
>> The PageLifeExpentancy and CacheHitRatio counters are still very valid
>> and
>> most useful for determining if you have memory pressure.
>> --
>> Andrew J. Kelly SQL MVP
>>
>> "Oscar" <Oscar@.discussions.microsoft.com> wrote in message
>> news:5B77575A-EE3C-41E5-8971-7436ADD59C37@.microsoft.com...
>> >I am finding conflicting opinions on how to monitor memory bottlenecks
>> >on
>> >AWE
>> > enabled systems. Can anyone provide any meaningfull info? I am aware
>> > of
>> > all
>> > the related performance counters. Howeve,r I do not know which one are
>> > still
>> > usefull once AWE is enabled. Also what are the accepable values for
>> > the
>> > AWE
>> > counters?
>> >
>> > Oscar Elleseff
>>
AWE Memory
I am finding conflicting opinions on how to monitor memory bottlenecks on AW
E
enabled systems. Can anyone provide any meaningfull info? I am aware of al
l
the related performance counters. Howeve,r I do not know which one are stil
l
usefull once AWE is enabled. Also what are the accepable values for the AWE
counters?
Oscar ElleseffThe PageLifeExpentancy and CacheHitRatio counters are still very valid and
most useful for determining if you have memory pressure.
Andrew J. Kelly SQL MVP
"Oscar" <Oscar@.discussions.microsoft.com> wrote in message
news:5B77575A-EE3C-41E5-8971-7436ADD59C37@.microsoft.com...
>I am finding conflicting opinions on how to monitor memory bottlenecks on
>AWE
> enabled systems. Can anyone provide any meaningfull info? I am aware of
> all
> the related performance counters. Howeve,r I do not know which one are
> still
> usefull once AWE is enabled. Also what are the accepable values for the
> AWE
> counters?
> Oscar Elleseff|||Thank You Andrew,
What about AWE specific counters? How can they be used to evaluate memory
pressure? For example, does 'AWE lookup/maps sec' have any applications in
this case and if it does what are the values we should be looking for?
Oscar Elleseff
"Andrew J. Kelly" wrote:
> The PageLifeExpentancy and CacheHitRatio counters are still very valid and
> most useful for determining if you have memory pressure.
> --
> Andrew J. Kelly SQL MVP
>
> "Oscar" <Oscar@.discussions.microsoft.com> wrote in message
> news:5B77575A-EE3C-41E5-8971-7436ADD59C37@.microsoft.com...
>
>|||If there is memory pressure in AWE or physical memory it will show up in the
counters mentioned. The AWE specific counters may be useful for some very
specific troubleshooting but you will see memory pressure first in the PLF &
CacheHit Ratio counters.
Andrew J. Kelly SQL MVP
"Oscar" <Oscar@.discussions.microsoft.com> wrote in message
news:C1B1A04D-ED6E-4306-8510-5D51D4E959A2@.microsoft.com...[vbcol=seagreen]
> Thank You Andrew,
> What about AWE specific counters? How can they be used to evaluate memory
> pressure? For example, does 'AWE lookup/maps sec' have any applications
> in
> this case and if it does what are the values we should be looking for?
> Oscar Elleseff
> "Andrew J. Kelly" wrote:
>
E
enabled systems. Can anyone provide any meaningfull info? I am aware of al
l
the related performance counters. Howeve,r I do not know which one are stil
l
usefull once AWE is enabled. Also what are the accepable values for the AWE
counters?
Oscar ElleseffThe PageLifeExpentancy and CacheHitRatio counters are still very valid and
most useful for determining if you have memory pressure.
Andrew J. Kelly SQL MVP
"Oscar" <Oscar@.discussions.microsoft.com> wrote in message
news:5B77575A-EE3C-41E5-8971-7436ADD59C37@.microsoft.com...
>I am finding conflicting opinions on how to monitor memory bottlenecks on
>AWE
> enabled systems. Can anyone provide any meaningfull info? I am aware of
> all
> the related performance counters. Howeve,r I do not know which one are
> still
> usefull once AWE is enabled. Also what are the accepable values for the
> AWE
> counters?
> Oscar Elleseff|||Thank You Andrew,
What about AWE specific counters? How can they be used to evaluate memory
pressure? For example, does 'AWE lookup/maps sec' have any applications in
this case and if it does what are the values we should be looking for?
Oscar Elleseff
"Andrew J. Kelly" wrote:
> The PageLifeExpentancy and CacheHitRatio counters are still very valid and
> most useful for determining if you have memory pressure.
> --
> Andrew J. Kelly SQL MVP
>
> "Oscar" <Oscar@.discussions.microsoft.com> wrote in message
> news:5B77575A-EE3C-41E5-8971-7436ADD59C37@.microsoft.com...
>
>|||If there is memory pressure in AWE or physical memory it will show up in the
counters mentioned. The AWE specific counters may be useful for some very
specific troubleshooting but you will see memory pressure first in the PLF &
CacheHit Ratio counters.
Andrew J. Kelly SQL MVP
"Oscar" <Oscar@.discussions.microsoft.com> wrote in message
news:C1B1A04D-ED6E-4306-8510-5D51D4E959A2@.microsoft.com...[vbcol=seagreen]
> Thank You Andrew,
> What about AWE specific counters? How can they be used to evaluate memory
> pressure? For example, does 'AWE lookup/maps sec' have any applications
> in
> this case and if it does what are the values we should be looking for?
> Oscar Elleseff
> "Andrew J. Kelly" wrote:
>
Thursday, February 16, 2012
average download rates for SQL Server
I have a SQL Server hosted on a Win2003 server. I have a monitor on the server letting me know the average download speeds. When I do a large select from a remote connection, it looks like the download rate maxes out at around 10 kb/sec.
Is this an average download rate for a server hosting sql server?
actually it looks like the 2003 servers download (via FTP at least) is much much faster. Is there a different configuration for SQL Server that could be limiting the download? I'm really just assuming that the download is limited because when I do a very large select from a remote computer, it takes around 30 seconds, but the download rate never goes above 10 kb/sec.
|||My first impression would be to verify that some network segment is not limiting to 10 MB.|||Your transfer rates will be limited to the transfer rate of the network or the speed of the hard drives.
Subscribe to:
Posts (Atom)