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

Question

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..

Muthu · Answer

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 Patel · Answer

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 Jadav · Answer

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.

Muthu · Answer

Hi Ritesh Thanks for your sharing..i expected result for a database not for table or files..

Ritesh Singh · Answer

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