Memory DMV's
in [Server Configuration]
|
From: Docco on 1 Dec 2009 06:30 Hi, I'm trying to use DMV's in order to get the actual memory consumption SQL Service is taking. I'd like to have the following values: - How much memory is currently allocated - What's the maximum size SQL Server is allowed to allocate. When looking at sys.dm_os_memory_clerks - [virtual_memory_reserved_kb] values is higher than what's defined on the server's configuration (and what I see in task manager as the actual memory usage the service is taking) virtual_memory_committed_kb does seem to be OK. What am I missing here? Thanks
From: Andrew J. Kelly on 1 Dec 2009 09:57 Look at the target and total memory counters for SQL Server Memory in Perfmon for that. -- Andrew J. Kelly SQL MVP Solid Quality Mentors "Docco" <adisapir(a)gmail.com> wrote in message news:6cb5261b-a03b-467c-858f-4a8af889465a(a)k4g2000yqb.googlegroups.com... > Hi, > I'm trying to use DMV's in order to get the actual memory consumption > SQL Service is taking. > I'd like to have the following values: > - How much memory is currently allocated > - What's the maximum size SQL Server is allowed to allocate. > > When looking at sys.dm_os_memory_clerks - [virtual_memory_reserved_kb] > values is higher than what's defined on the server's configuration > (and what I see in task manager as the actual memory usage the service > is taking) > > virtual_memory_committed_kb does seem to be OK. > > What am I missing here? > > Thanks
From: Docco on 1 Dec 2009 10:22 On Dec 1, 4:57 pm, "Andrew J. Kelly" <sqlmvpnooos...(a)shadhawk.com> wrote: > Look at the target and total memory counters for SQL Server Memory in > Perfmon for that. > > -- > > Andrew J. Kelly SQL MVP > Solid Quality Mentors > > "Docco" <adisa...(a)gmail.com> wrote in message > > news:6cb5261b-a03b-467c-858f-4a8af889465a(a)k4g2000yqb.googlegroups.com... > > > > > Hi, > > I'm trying to use DMV's in order to get the actual memory consumption > > SQL Service is taking. > > I'd like to have the following values: > > - How much memory is currently allocated > > - What's the maximum size SQL Server is allowed to allocate. > > > When looking at sys.dm_os_memory_clerks - [virtual_memory_reserved_kb] > > values is higher than what's defined on the server's configuration > > (and what I see in task manager as the actual memory usage the service > > is taking) > > > virtual_memory_committed_kb does seem to be OK. > > > What am I missing here? > > > Thanks I was looking for a query that does that. Anyway, I actually found my solution in the meantime - using sys.dm_os_sys_memory. Thing is, it only exists on 2008+ Regarding the maximum 'allowed' allocation - the numbers can be found on sys.configurations Thanks for the help
From: Andrew J. Kelly on 1 Dec 2009 13:03 You can get these from the sys.dm_os_performance_counters DMV as well if you want to run a query for the results. -- Andrew J. Kelly SQL MVP Solid Quality Mentors "Docco" <adisapir(a)gmail.com> wrote in message news:9824d90d-2c70-44db-a3d4-9b58de8ae674(a)v25g2000yqk.googlegroups.com... > On Dec 1, 4:57 pm, "Andrew J. Kelly" <sqlmvpnooos...(a)shadhawk.com> > wrote: >> Look at the target and total memory counters for SQL Server Memory in >> Perfmon for that. >> >> -- >> >> Andrew J. Kelly SQL MVP >> Solid Quality Mentors >> >> "Docco" <adisa...(a)gmail.com> wrote in message >> >> news:6cb5261b-a03b-467c-858f-4a8af889465a(a)k4g2000yqb.googlegroups.com... >> >> >> >> > Hi, >> > I'm trying to use DMV's in order to get the actual memory consumption >> > SQL Service is taking. >> > I'd like to have the following values: >> > - How much memory is currently allocated >> > - What's the maximum size SQL Server is allowed to allocate. >> >> > When looking at sys.dm_os_memory_clerks - [virtual_memory_reserved_kb] >> > values is higher than what's defined on the server's configuration >> > (and what I see in task manager as the actual memory usage the service >> > is taking) >> >> > virtual_memory_committed_kb does seem to be OK. >> >> > What am I missing here? >> >> > Thanks > > > I was looking for a query that does that. > Anyway, I actually found my solution in the meantime - using > sys.dm_os_sys_memory. Thing is, it only exists on 2008+ > Regarding the maximum 'allowed' allocation - the numbers can be found > on sys.configurations > > Thanks for the help
|
Pages: 1 Prev: Waitstats Performance on sql 2005 Next: VDI backup slows down |