SQL server job execution time
-
Hello All, We have job set up on a newly built server, windows 2012, with sql server 2012. We have a job set up to run everyday. The first day the job ran look 7 hours. Slowly, over one months time it has creeped up to 8 hours now. We are puzzled as to why this steady increase in time. WE have confirmed with our network folks no other job/process is running on the viritual server at the same time. Looked at the event viewer, nothing to report. Is there any other place i could view the logs to get a better insight? thanks!
-
Hello All, We have job set up on a newly built server, windows 2012, with sql server 2012. We have a job set up to run everyday. The first day the job ran look 7 hours. Slowly, over one months time it has creeped up to 8 hours now. We are puzzled as to why this steady increase in time. WE have confirmed with our network folks no other job/process is running on the viritual server at the same time. Looked at the event viewer, nothing to report. Is there any other place i could view the logs to get a better insight? thanks!
VK19 wrote:
Looked at the event viewer, nothing to report. Is there any other place i could view the logs to get a better insight?
Perhaps, in SQL Server Logs?
-
VK19 wrote:
Looked at the event viewer, nothing to report. Is there any other place i could view the logs to get a better insight?
Perhaps, in SQL Server Logs?
-
Would the logs files be in the following location:
\Program Files\Microsoft SQL Server\MSSQL11.MSSQLSERVER\MSSQL\Log
It seems to be correct. My Logs are in C:\Program Files\Microsoft SQL Server\MSSQL12.MSSQLSERVER\MSSQL\Log Alternatively you can see the log in SSMS under Object Explorer -> Management -> SQL Server Logs
-
Hello All, We have job set up on a newly built server, windows 2012, with sql server 2012. We have a job set up to run everyday. The first day the job ran look 7 hours. Slowly, over one months time it has creeped up to 8 hours now. We are puzzled as to why this steady increase in time. WE have confirmed with our network folks no other job/process is running on the viritual server at the same time. Looked at the event viewer, nothing to report. Is there any other place i could view the logs to get a better insight? thanks!
What is the nature of this job? Does it create records ? Or read the data? How big is this database ? How are many disks are installed on the server? How are they being used by the database engine? Are the Operating System and database files on different disks? On the database server from a command prompt type "perfmon" to bring up the Performance Monitoring Utility. You want to add a counter for Logical disk / Avg Disk Queue Length (All disks) Look at the graph while the job is running, if you see high activity on one disk and low activity on another disk, you may want to consider moving some DB files around. Here are a couple of things to consider: 1) Count the number of rows in the tables involved. Check these values daily, weekly, monthly. 2) Identify the tables that are growing. 3) Are there indexes on these tables? Check the fragmentation of the indexes. Possible create new indexes or revise existing ones. NOTE: Be careful when adding indexes, it may help your one job, but have a negative impact on the rest of the system. With the limited information given, I'm giving you some basic areas to investigate. I'll be glad to help you. :cool: