How do I send my server’s data to you?
You run a lightweight collector application on a Windows desktop or laptop (not your SQL Server) that performs a small data collection once per day. It runs quickly and has minimal impact – it’s not collecting anything heavy. The collector app is standalone, no install required and can even update itself if you leave that setting turned on. From time to time, new collection diagnostics might be added and we want you to be able to benefit from these without you having to worry about installs.
How many servers can I analyse?
As many as you like. SQLFrontline is priced per user, not server. You can analyse all of your SQL servers including Dev, Test, UAT and DR boxes. You sign up with your email address and recommendations get sent to you via your email.
What SQL Server versions do you support?
SQL Server 2008 and newer. Microsoft stopped all support for SQL Server 2005 in April 12, 2016. Since Microsoft aren’t supporting it, we decided we wouldn’t either.
What’s the data collection overhead?
It’s very, very low. It only collects a limited amount of data once per day, and you can choose the time. It’s unlikely you will even notice it running.
What data gets collected?
We collect data about your SQL Server’s configuration, wait stats, backups, etc. We do not collect any of your application data. You can examine all the data that we collect.
We don’t collect execution plans, statistics, memory dumps, or passwords. In future releases, you’ll be able to opt in to collect information about your query plans and statistics.
What’s done with that data?
SQLFrontline gets diagnostic data from your SQL Server, encrypts it, sends it to secure cloud storage where we extract it and load into an encrypted database, analyse it, and build an email to send to you.
We analyse each of your servers and provide you with personal emails with recommendations on how to make your server faster and more reliable. We do not share or sell any of your server’s raw data and never will.