tedatadcu
asked on
ms sql server helth check
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
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
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
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.
ASKER
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