SQL Server edition to chose

Real-time performance monitoring and troubleshooting

Re: SQL Server edition to chose

Veeam Logoby EBoucq » Fri Oct 16, 2015 3:07 pm

Here is the result of the query:

https://gyazo.com/9c831fdce69e60f3b24371d2ec4b1e86

I chose 3 months retention policy. Does that mean I can't keep more information since the database is already close to 10 GB ? I'd like to keep data for at least 6 months.

Thanks.
EBoucq
Expert
 
Posts: 213
Liked: 14 times
Joined: Fri Jan 21, 2011 10:10 am
Full Name: Eric Boucq

Re: SQL Server edition to chose

Veeam Logoby Vitaliy S. » Fri Oct 16, 2015 3:52 pm

Hmm... Yes, it seems like 10 GBs will not be enough for live 200 VMs and 6 hosts (btw, good ratio for VMs per host!). The reason for this is that we keep 20 seconds for the last hour for every metric and for every object. In addition to this 5 minutes data samples are stored for the past 14 days for granular past performance reporting.

Given all that, I would suggest either to switch to a full version of SQL Server, select advanced scalability mode or you can ask our support to assist you with disabling some performance counters you don't plan to monitor. Hope this helps!
Vitaliy S.
Veeam Software
 
Posts: 19558
Liked: 1102 times
Joined: Mon Mar 30, 2009 9:13 am
Full Name: Vitaliy Safarov

Re: SQL Server edition to chose

Veeam Logoby btmaus » Thu Oct 22, 2015 3:19 am

I am having the exact same problem, 22 VMware hosts and 400 VMs. Database is full within a couple of days. monitor.PerfSampleMed is the main culprit.
btmaus
Expert
 
Posts: 128
Liked: 9 times
Joined: Fri Jul 17, 2015 9:02 am
Full Name: Glenn L

Re: SQL Server edition to chose

Veeam Logoby Vitaliy S. » Thu Oct 22, 2015 9:25 am

Yes, for 400 VMs I would expect the database to outgrow 10 GBs due to granular performance data samples collection. Maybe it makes sense to limit the number of collected performance counters in the next updates or have an option in the UI to control that.
Vitaliy S.
Veeam Software
 
Posts: 19558
Liked: 1102 times
Joined: Mon Mar 30, 2009 9:13 am
Full Name: Vitaliy Safarov

Previous

Return to Monitoring



Who is online

Users browsing this forum: No registered users and 3 guests