SQL Program - Growth almost 1 Gb of RAM

Real-time performance monitoring and troubleshooting

SQL Program - Growth almost 1 Gb of RAM

Veeam Logoby tcpjsm » Fri Mar 13, 2009 11:47 am

Running and monitoring and ESXi server, after a short amount of time, the sqlservr program grows to almost hit 1 Gb or RAM. This doesn't seem or should be normal. Any suggestions? :?: :shock:
tcpjsm
Novice
 
Posts: 8
Liked: never
Joined: Wed Feb 18, 2009 10:43 pm

Re: SQL Program - Growth almost 1 Gb of RAM

Veeam Logoby Gostev » Fri Mar 13, 2009 12:16 pm

This is really not related to Veeam Monitor, rather to Microsoft SQL design. When actively working, and in case when computer has sufficient memory available, Microsoft SQL reserves some of the memory to work faster.

You can always reduce the maximum size of reserved memory by going into Management Studio, right-clicking the database, selecting Properties, Memory tab. Although there is little sense to do it, best is to leave the default settings for performance reasons.
Gostev
Veeam Software
 
Posts: 21396
Liked: 2349 times
Joined: Sun Jan 01, 2006 1:01 am
Location: Baar, Switzerland


Return to Monitoring



Who is online

Users browsing this forum: Yahoo [Bot] and 4 guests