virtualDBA

Fully Automated Database Maintenance, Monitoring and Auditing.

What’s planned for virtualDBA v3.7.0

No Comments »

Integrated Windows Service Monitoring/Alerting

If you’re a smaller company with no current service state monitoring, you can now enable this option directly in virtualDBA.  Do you have have custom application services running on remote hosts?  If so, let virtualDBA alert you when they are down!

SQL Agent Job Analysis/Trending

Introduced a new process that will track and report on the trending of your application (or any other) SQL Agent jobs on an instance of SQL Server. Get aggregated run-time statistics, percent failure/success ratios, etc for any of your scheduled jobs.

Query memory and STC monitoring

Track per query memory allocation and Subtree Costs (STC) and send alerts on predefined threshold values.  If a query is sorting in TempDB outside of it’s granted memory space have virtualDBA log it and notify you.  If a query has a high STC value, have virtualDBA log it and notify you.  If a query is requesting a large amount of memory space have virtualDBA log it and notify you.  Starting to see the trend here?

A revamped Query Statistics Monitor

On a loaded system (>1200 batch request/sec), we are seeing some of the query statistics monitors taking over 15 sec to complete.  Our code revisions should help to alleviate this situation.

Further performance improvements across all monitoring processes.

We’re always trying to improve the performance of every virtualDBA process to ensure that is uses the minimal amount of server resources as possible.

There are a few more cool new features we will be adding but we’ll keep those under wraps until the release!

Stay Tuned!

virtualDBA v3.6.0 is now available!

No Comments »

Version 3.6.0 of virtualDBA is now available for download!

Our Forums

No Comments »

Our Forums are now online!

You can access them at: http://forums.virtualdba.ca

Over the next few weeks we will be making a few changes here and there but we still invite you to register and contribute to the virtualDBA community.

Ask questions, provide feedback/comments, post some tips-and-tricks, anything you want!

Next Steps

No Comments »

So what’s next on the migration agenda?  Forums!

We are going to be setting up our Community Forums to allow virtualDBA users to get assistance and share ideas, tips and tricks with other virtualDBA users.

Stay tuned!