Want to win a PS4? Go Premium and enter to win our High-Tech Treats giveaway. Enter to Win

x
?
Solved

ms sql server helth check

Posted on 2014-04-29
3
Medium Priority
?
171 Views
Last Modified: 2014-10-08
hi

i use third party software (data base healthy check) and the website for this product is databasehealth.com this product give me report put in this time and i need this report daily
 if you have any program to give me report daily for the below parameter

or analyzing the existing loges to generate the health report
 
connections by database
cpu used by database
memory used by database
page read by database
page write by database
plane cach by database
query needing params by database
waits by type
0
Comment
Question by:tedatadcu
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
3 Comments
 
LVL 8

Accepted Solution

by:
ProjectChampion earned 2000 total points
ID: 40029332
Hi tedatadcu,
There are a number of products in the market that you can use for monitoring all aspects of your SQL Server e.g. take a look at Red Gate or Idera. The obvious advantage of these monitoring tools is that they'll keep you aware of the status f the server constantly (rather than just getting an email once a day) and provide you with a myriad of ways to get notified when certain errors/events happen or specific metrics exceed the set thresholds. However as you'll see they are not cheap. : )


The good news is that you can get all of the above metrics from your SQL Server directly for instance using DMVs (dynamic management views) or DMFs (dynamic management functions) or querying system tables and views directly...
Also you can use the existing SQL Server features (scheduled jobs, alerts, dbmail, etc.) to stay on top of the health status of your server around the clock.

If you're interested I can help you with writing the queries to capture all of the the above metrics (and more) but you'll have to do some work to get the result in the desired format and set up alerting mechanism to send you notification emails/messages when needed. Also implementing monitoring each of those metrics merit a separate question.
0
 

Author Comment

by:tedatadcu
ID: 40029421
Dear ProjectChampion

thank you for fast response i already have some query that give me the result and also data base healthy check software but i need the average result in 24 hour because the software give me the result in the specific time when running it and also i need to save this result if i need to check it again in any time

Thanks
0
 
LVL 8

Expert Comment

by:ProjectChampion
ID: 40053572
Then perhaps Red Gate SQL Monitor is what you are looking for. You can download a fully functioning trial copy that works for 14 days and give it a try. Apart from monitoring and alerts, it has a section labeled "Analysis" where you can see the current and historical stats for all those metrics and more. You can also define and configure your own custom metrics.
0

Featured Post

Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This article explains how to reset the password of the sa account on a Microsoft SQL Server.  The steps in this article work in SQL 2005, 2008, 2008 R2, 2012, 2014 and 2016.
In this article we will learn how to fix  “Cannot install SQL Server 2014 Service Pack 2: Unable to install windows installer msi file” error ?
Familiarize people with the process of retrieving data from SQL Server using an Access pass-thru query. Microsoft Access is a very powerful client/server development tool. One of the ways that you can retrieve data from a SQL Server is by using a pa…
This videos aims to give the viewer a basic demonstration of how a user can query current session information by using the SYS_CONTEXT function

636 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question