How to find a database peek hours in a day?..

Muthu

10y1.3k

 i need to find when database heavily used in a day.. example 01-02 am it's not used heavily..15-16 pm it's used heavily.. is there is any option/query  available to find like that please reply me..

5 Replies

Know the answer? Post it — somebody with the same question will find it here.

Muthu10y ago
please use this links for reference
http://blog.extreme-advice.com/2012/12/06/transactionssec-and-batch-requestssec-performance-counter-in-sql-server/
http://www.connectsql.com/2011/01/sql-server-how-to-figure-out-peakoff.html
Tapan Patel10y ago
You can view the SQL Server Log files for the specific date and then apply filter with Message name (contains Your DB name).
Once you have the filter applied, export that log to csv format and then you can analyze using Excel.
Please mark it as an answer if that addresses the issue.
Vishal Jadav10y ago
Hi Muthu,
I am aware of how to get much time consuming query in sql by using SQl server reports.
You can get the path to query with help of attached screenshot in zip file.
Right click on your database and follow the menu you will get many options in reports.
Hope it helps.
Thanks.
Muthu10y ago
Hi Ritesh,
Thanks for your sharing..i expected result for a database not for table or files..
Ritesh Singh10y ago
Hi,

Please visit below nice link:

http://stackoverflow.com/questions/11934818/how-do-i-get-the-peak-hours-from-my-mysql-database-table-userlog
http://stackoverflow.com/questions/369908/sql-statement-to-collect-data-in-a-day-by-day-hour-for-hour-fashion
http://stackoverflow.com/questions/9842094/sql-how-can-i-get-the-number-of-executed-queries-per-database-or-hour-or
http://stackoverflow.com/questions/12223109/sql-to-determine-peak-volume-and-hour-for-all-days
Note: Please accept the answer if it help you and answer your question.

Thanks & Regards,
Ritesh