Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
Author |
Topic |
phaniprasad18
Starting Member
3 Posts |
Posted - 2013-06-18 : 01:30:24
|
Hi,I am Phani, beginner to SQL Server. I would like to know the IDLE time of SQL SERVER (If there are no hits or no active sessions from past 30 mins, consider it as IDLE TIME) without logging in. Could you please tell me any script (Batch or Power Shell or VB) or other ways to find out.Thanks in advance.Regards,Phani T |
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2013-06-18 : 02:28:35
|
http://exacthelp.blogspot.com/2012/04/sql-script-to-get-cpu-idle-time-in-sql.html------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/https://www.facebook.com/VmBlogs |
|
|
phaniprasad18
Starting Member
3 Posts |
Posted - 2013-06-19 : 01:28:52
|
Hi Visakh,Thanks a lot, but I need to know the SQL Server IDLE time without logging into SQL, either it should be any script or any other software.Could you please tell suggest anyone of them.Regards,Phani T.Phani T |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2013-06-19 : 01:37:29
|
why not automate it by menas of sql agent job and make it log the results onto some file or a report so that you can check it without even logging to sql server?------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/https://www.facebook.com/VmBlogs |
|
|
ahmeds08
Aged Yak Warrior
737 Posts |
|
|
|
|