Real-time performance monitoring and troubleshooting
Post Reply
tcpjsm
Novice
Posts: 8
Liked: never
Joined: Feb 18, 2009 10:43 pm
Contact:

SQL Program - Growth almost 1 Gb of RAM

Post by tcpjsm »

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:

Gostev
SVP, Product Management
Posts: 26715
Liked: 4279 times
Joined: Jan 01, 2006 1:01 am
Location: Baar, Switzerland
Contact:

Re: SQL Program - Growth almost 1 Gb of RAM

Post by Gostev »

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.

Post Reply

Who is online

Users browsing this forum: No registered users and 2 guests