SQL SERVER ASSESSMENTS

THE PERFECT WAY TO MAINTAIN AND DOCUMENT SQL SERVER

THE PERFECT TOOL FOR SERVICING CLIENTS WITH SQL SERVERS

The Network Detective SQL Server Assessment Module gives you the tools you need to properly manage the networks for any clients with applications running on SQL Server – including SharePoint.

The tool is so easy to use that non-DBA service techs can quickly and easily run the scan and generate all the reports needed for maintaining and reporting the status of an SQL Server database.

Yet the information delivered in the reports is powerful enough to give even the savviest Database Administrators insight to assess potential threats and overall health of the databases BEFORE something critical goes wrong.

Click on the How It Works Tab for a quick video describing the process.

SEPARATE YOURSELF FROM THE COMPETITION

Other MSPs and Service Providers may offer IT assessments, and some of your competitors may even subscribe to one or two Network Detective modules.

But only the "serious" players who go after larger clients will be digging into the SQL Server database, looking for threats that others have missed. All it takes is the SQL Server Assessment Module to "unlevel" the playing field in your favor.

This module has tons of uses. When employed alongside the other Network Detective modules, you can deliver for your clients and prospects a comprehensive IT assessment worth thousands of dollars. Whether or not you charge, the value will be apparent and will trump whatever reports other service providers might deliver.

Or use the SQL Server Assessment module on its own as part of your regular service delivery program, or as part of a stand-alone project.

YOU GET 5 POWERFUL, BRANDABLE REPORTS

As with the other Network Detective modules, the true value of this offering is the fabulous, data-rich reports that you can quickly generate:

  • Routine Health Report - shows the health of the SQL Server at a high level. Looks at best practices and compares them to the current state of the database
  • SQL Server Detail Report - documents key settings of the SQL server, including cluster information, DB recovery model, location of critical files, I/O, physical memory, wait types, logins and more
  • Database Detail Report - Deeper dive into each individual database in the SQL server, including properties, missing indices, fragmentation levels and other stats
  • Maintenance Plan Report- A very telling report that reveals which defined maintenance plans have been run, the last run times and results. The report includes the sub-steps taken in the plans
  • SQL Server Agent Jobs Report - This report includes a comprehensive list of all SQL Server agent jobs and their schedules.
    The Job History highlights which jobs were not successful, and why they are producing errors

With the SQL Server Assessment Module, all you need to do is run the special Network Detective non-invasive data collector on your client's or prospect's SQL Server. Then, let the Network Detective's proprietary data analyzer crunch the network data and produce a set of SQL Server reports for you. Brand them as your own, and present them either as a stand-alone, one-time assessment of the health of the SQL Server, or as part of a regularly-scheduled database management and maintenance service.

Click on the Reports Tab for descriptions of each report, to download samples, and to watch a short video that reviews key report elements.

SUPPLEMENT THESE REPORTS WITH INFORM

Network Detective includes our powerful InForm auxiliary report engine. Working from a large library of pre-loaded Best Practice topics and questions, you can:

  • Create check lists to ensure your techs follow your SQL Server maintenance procedures
  • Create interview questions to remember to ask your client or prospect about performance or other issues
  • Create a data survey of items to manually check or inspect to supplement your automated assessment
  • Generate an SQL Server SWOT Analysis to help your client understand the pros and cons of their current SQL Server environment

Click here to view a quick demonstration of this important feature.

A "MUST HAVE" ADDITION TO YOUR RMM TOOLS

Even if you already have an RMM system, it can't actually "document" the SQL Server settings – valuable information you will need beyond the actual back-up to improve Disaster Recovery.

Database fragmentation and missing indices are other items that an RMM won't report on until they cause issues. The SQL Server Assessment module will help you spot these symptoms before they create big problems.

Click on the Uses Tab for more details and to watch a video on this topic.

TRY IT NOW

With our 100% satisfaction guarantee, there's absolutely no risk to you. You have everything to win and nothing to lose. Go ahead and subscribe to the SQL Server Assessment Module right now. Run the scan on your own network or on a few of your client sites. Generate the reports. You'll have a full 30 days to put the tool through its paces. If during that time you decide that this product is not for you, just tell us and we'll cancel your subscription and provide you with a 100% refund of your purchase price. Best of all, the more modules you buy at the same time, the less you pay!

OUR REPORTS UNCOVER ALL YOU NEED TO KNOW!

Once you collect the SQL Server data using our agentless scanning tool, the rest is a cakewalk. Just import the scan results into our proprietary risk analyzer, customize the reports with your own company name and branding elements, and run the reports. Subscribe to the SQL Server Assessment Module and you'll be able to produce an UNLIMITED number of all the reports, on an unlimited number of networks, for a full year.

MAKE OUR REPORTS YOUR REPORTS!

All Network Detective subscriptions include our Enhanced Branding Package, which gives you the ability to control the overall look-and-feel of the reports you generate. With the Enhanced Branding package, you can:

  • Personalize the reports with your company name and logo
  • Change the accent colors to match your own company standards
  • Select from a number of pre-designed report templates
  • Embellish your reports with photos and images from our pre-screened, royalty-free library

REPORTS INCLUDED IN THE SQL SERVER ASSESSMENT SUBSCRIPTION

Routine Health Report. This report assesses the health of the SQL Server using three major categories. These include settings, file, and resources. Setting health looks for configuration issues that may go against prescribed best practices. File health looks at how the database interacts with the file system, looking for adequate space and compares the current configuration versus best practices. Resource health looks to ensure adequate resources are available to operate the SQL Server optimally and looks for indicators pointing to performance issues. Resource health comprises of three sub-categories – wait health, task health, and memory health. Wait health deals with issues with database processing waits and delays. Task health validates that scheduled tasks and jobs are working optimally. Memory health looks to ensure adequate memory is available to run the SQL Server properly.
SQL Server Detail Report. This report details the settings and health of the SQL Server as a whole. It looks at settings, configuration, performance, and backup. Information and detailed breakdown of databases can be found in the Database Detail report.
Database Detail Report. This report details the settings and health of individual databases that reside on the scanned SQL Server. It lists the database properties, potentially missing indexes, locks, statistics, fragmentation, and existing indexes. Without this tool, it would be a daunting task to collect all this information. Because this report documents each database individually, it can be run ad-hoc when specific database performance problems arise. But best practice is not to wait and react to these problems but plan to run this report on a regular basis (quarterly or monthly, depending upon the how critical the application is). This report will help identify opportunities to improve performance and accumulate trending data that will help you anticipate problems before they occur. The report is also a great way to document your work for both internal and external uses.
Maintenance Plan Report. This report details all maintenance plans and their sub-plans. Maintenance plans perform routine tasks on your SQL Server. Not all maintenance plans are active and in-use, and you can use the report to document what’s in place and if adequate automation of maintenance and backups are being performed.
SQL Server Agent Jobs Report. This report details all jobs (active and inactive) for the SQL Server agent. Some jobs may be maintenance plans and can be seen in detail in the Maintenance Plan Detail report (see above). Look in the Job History section of this report for entries in RED or that do not say "success" and see what jobs are causing errors and why. This report is so simple to generate, even non-DBA tech can use it to check for errors in jobs. And since some Remote Monitoring and Management (RMM) tools do not delve into the actual database level, it makes sense to run this report monthly to supplement your RMM tool, and also to keep it "honest."

SUPPLEMENT THESE REPORTS WITH INFORM

Network Detective includes our powerful InForm auxiliary report engine. Working from a large library of pre-loaded Best Practice topics and questions, you can:

  • Create check lists to ensure your techs follow your SQL Server maintenance procedures
  • Create interview questions to remember to ask your client or prospect about performance or other issues
  • Create a data survey of items to manually check or inspect to supplement your automated assessment
  • Generate an SQL Server SWOT Analysis to help your client understand the pros and cons of their current SQL Server environment

TRY IT NOW

The SQL Server Assessment Module is sold separately, but may be purchased at a discount when combined with other Network Detective modules purchased at the same time. With our 100% satisfaction guarantee, and 30-day evaluation period, there's absolutely no risk to you. You have everything to gain and nothing to lose.

Go ahead and subscribe to the SQL Server Assessment Module right now. Run the scan on your own SQL Server (if you have one internally) or on a few of your client sites. Generate the reports. You'll have a full month to put the tool through its paces. If during that time you decide that this product is not for you, just tell us and we'll cancel your subscription and provide you with a 100% refund.

Best of all, the more modules you buy at the same time, the less you pay!

THE PERFECT TOOL FOR ANYONE RESPONSIBLE FOR MAINTAINING SQL SERVERS

The Network Detective SQL Server Assessment Module is the perfect tool for anyone who is charged with managing and supporting applications running on SQL Server – including SharePoint.

If you are a SQLServer DBA, this module will help you identify threats to, and assess the overall health of, the mission-critical databases on the SQL Server, as well as the server itself. Unlike anything else on the market, the reports from this tool will provide you with the data you need to resolve reported issues, as well as to pro-actively prevent others from occurring.

If you are a non-DBA service tech who is tasked with maintaining and reporting on a SQL Server database, this tool is the perfect way for you to collect all the data you need to determine its overall health. Even if you can't remediate the issues yourself, you'll have all the documentation you need to get the aid or advice from a specialized DBA.

If you are a service provider looking to differentiate yourself from the competition, use this module as part of a comprehensive IT Assessment that will blow the doors off of anything your competitors can deliver, and in a faction of the time.

If you are looking to expand your service portfolio, use the reports from this tool to create a new SQL Server Maintenance program – either as a value-add to your standard service offering, or to generate incremental revenue as a stand-alone service.

TRY IT NOW

The SQL Server Assessment Module is sold separately, but may be purchased at a discount when combined with other Network Detective modules purchased at the same time. With our 100% satisfaction guarantee, and 30-day evaluation period, there's absolutely no risk to you. You have everything to gain and nothing to lose.

Go ahead and subscribe to the SQL Server Assessment Module right now. Run the scan on your own SQL Server (if you have one internally) or on a few of your client sites. Generate the reports. You'll have a full month to put the tool through its paces. If during that time you decide that this product is not for you, just tell us and we'll cancel your subscription and provide you with a 100% refund.

Best of all, the more modules you buy at the same time, the less you pay!

IT'S AS EASY AS 1-2-3

The beauty about all Network Detective modules is how simple the entire process is, from initial set up to delivery of a comprehensive and professional assessment. And the SQL Assessment module is no exception.

With this module you get a separate Network Detective data collector that is designed specifically for performing the SQL Server Assessment. And as with our other data collectors, the tool is completely non-invasive. Nothing is installed - the self-extracting .EXE can be run from a thumb-drive, or downloaded from our website as needed.

If you are doing an assessment on an on-premise SQL Server, you'll need to run the scan tool anywhere you can access the SQL Server using Management Studio. And, of course, you don't need to physically be there. If you can remote into the machine, then you can perform the data collection right from your office.

Just like the other Network Detective scanning tools, as soon as the scan is complete a zip file containing the encrypted results of the scan will be generated and saved to the location your specify. Simply grab that file, and import it into Network Detective to have the data instantly analyzed for the reports you want to generate.

TRY IT NOW

The SQL Server Assessment Module is sold separately, but may be purchased at a discount when combined with other Network Detective modules purchased at the same time. With our 100% satisfaction guarantee, and 30-day evaluation period, there's absolutely no risk to you. You have everything to gain and nothing to lose.

Go ahead and subscribe to the SQL Server Assessment Module right now. Run the scan on your own SQL Server (if you have one internally) or on a few of your client sites. Generate the reports. You'll have a full month to put the tool through its paces. If during that time you decide that this product is not for you, just tell us and we'll cancel your subscription and provide you with a 100% refund.

Best of all, the more modules you buy at the same time, the less you pay!

TRY IT NOW

The SQL Server Assessment Module is sold separately, but may be purchased at a discount when combined with other Network Detective modules purchased at the same time. With our 100% satisfaction guarantee, and 30-day evaluation period, there's absolutely no risk to you. You have everything to gain and nothing to lose.

Go ahead and subscribe to the SQL Server Assessment Module right now. Run the scan on your own SQL Server (if you have one internally) or on a few of your client sites. Generate the reports. You'll have a full month to put the tool through its paces. If during that time you decide that this product is not for you, just tell us and we'll cancel your subscription and provide you with a 100% refund.

Best of all, the more modules you buy at the same time, the less you pay!