SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


SQL Server Agent 2012 - Slow on startup and closure


SQL Server Agent 2012 - Slow on startup and closure

Author
Message
erik_ee
erik_ee
Forum Newbie
Forum Newbie (3 reputation)Forum Newbie (3 reputation)Forum Newbie (3 reputation)Forum Newbie (3 reputation)Forum Newbie (3 reputation)Forum Newbie (3 reputation)Forum Newbie (3 reputation)Forum Newbie (3 reputation)

Group: General Forum Members
Points: 3 Visits: 30
Dear SQL users,

Since couple of weeks we've been working with SQL Server 2012 (Microsoft SQL Server 2012 - 11.0.2100.60 (X64) Standard Edition (64-bit) (Build 7601: Service Pack 1). We still have our old production centre which works on SQL Server 2005.

The problem lies within the SQL Server Agent, all Agent settings are similar to our good working 2005 environment. A simple job with single t-sql step 'select @@version' takes over 40 seconds in 2012 and < 1 second in 2005 environment. Running the query in 2012 query window it has the same (expected) performance of < 1 sec.

What is it that makes the 2012 Agent so slow?

Interesting is that the job step takes 6 seconds and the total job takes 40 seconds.

Any ideas??

Thanks in advance,
Gr. Erik
Attachments
SS2012.png (10 views, 6.00 KB)
j.miner
j.miner
SSC-Enthusiastic
SSC-Enthusiastic (150 reputation)SSC-Enthusiastic (150 reputation)SSC-Enthusiastic (150 reputation)SSC-Enthusiastic (150 reputation)SSC-Enthusiastic (150 reputation)SSC-Enthusiastic (150 reputation)SSC-Enthusiastic (150 reputation)SSC-Enthusiastic (150 reputation)

Group: General Forum Members
Points: 150 Visits: 358
The sql server agent job runs under the credentials of the service account.

Question 1 - Do you have the same performance issue when logging into SSMS using that account?


The min / max memory settings are sometimes forgotten about when building out a new server.

Question 2 - Did you use the correct settings?

http://www.sqlservercentral.com/blogs/glennberry/2009/10/29/suggested-max-memory-settings-for-sql-server-2005_2F00_2008/


Question 3 - Is this a physical or virtual server that you have SQL Server installed on? If it is a virtual server, there can be issues with the ballon memory manager, I am not a VM expert.


Question 4 - Make sure you have the latest service pack and cummulative updates for SQL Server 2012.


Please answer these questions. It will give me a better idea of what you are dealing with.

John Miner
Crafty DBA
www.craftydba.com
erik_ee
erik_ee
Forum Newbie
Forum Newbie (3 reputation)Forum Newbie (3 reputation)Forum Newbie (3 reputation)Forum Newbie (3 reputation)Forum Newbie (3 reputation)Forum Newbie (3 reputation)Forum Newbie (3 reputation)Forum Newbie (3 reputation)

Group: General Forum Members
Points: 3 Visits: 30
SQL Server and Agent both run under LocalSystem.
Q1: In SSMS query window nog performance delay, its <1 second.
Q2: Yes, 12GB, 3GB free of RAM
Q3: Its virtual (hypervisor)
Q4: Installed 11.0.0.3000 this morning (SP1), still same issue

I've managed to narrow the problem, it looks like a delay on SQL Server Agent. When i reboot the SQL Server Agent through services it takes up to 45 seconds to stop the server and 5 seconds to start it. Same on my old SQL 2005 server is done under 10 seconds.

What causes the delay in stopping SQL Server Agent?


Erik



j.miner (4/4/2013)
The sql server agent job runs under the credentials of the service account.

Question 1 - Do you have the same performance issue when logging into SSMS using that account?

The min / max memory settings are sometimes forgotten about when building out a new server.

Question 2 - Did you use the correct settings?

http://www.sqlservercentral.com/blogs/glennberry/2009/10/29/suggested-max-memory-settings-for-sql-server-2005_2F00_2008/


Question 3 - Is this a physical or virtual server that you have SQL Server installed on? If it is a virtual server, there can be issues with the ballon memory manager, I am not a VM expert.


Question 4 - Make sure you have the latest service pack and cummulative updates for SQL Server 2012.


Please answer these questions. It will give me a better idea of what you are dealing with.


j.miner
j.miner
SSC-Enthusiastic
SSC-Enthusiastic (150 reputation)SSC-Enthusiastic (150 reputation)SSC-Enthusiastic (150 reputation)SSC-Enthusiastic (150 reputation)SSC-Enthusiastic (150 reputation)SSC-Enthusiastic (150 reputation)SSC-Enthusiastic (150 reputation)SSC-Enthusiastic (150 reputation)

Group: General Forum Members
Points: 150 Visits: 358
Definitely a VM hypervisor issue.

I would do a google search. Maybe post under a VM / SQL forum.

We use hyper-v for test boxes only. Do not have this issue.

All production boxes are physical hardware!

Makes like fast and easy, the way I like it!

:-P

John Miner
Crafty DBA
www.craftydba.com
erik_ee
erik_ee
Forum Newbie
Forum Newbie (3 reputation)Forum Newbie (3 reputation)Forum Newbie (3 reputation)Forum Newbie (3 reputation)Forum Newbie (3 reputation)Forum Newbie (3 reputation)Forum Newbie (3 reputation)Forum Newbie (3 reputation)

Group: General Forum Members
Points: 3 Visits: 30
Thanks, I will try a hypervisor/sql forum!
mattjonesits
mattjonesits
Forum Newbie
Forum Newbie (3 reputation)Forum Newbie (3 reputation)Forum Newbie (3 reputation)Forum Newbie (3 reputation)Forum Newbie (3 reputation)Forum Newbie (3 reputation)Forum Newbie (3 reputation)Forum Newbie (3 reputation)

Group: General Forum Members
Points: 3 Visits: 10
We have it working ok under Hyper-V.
Maybe something specific to your hyper-v setup.

Matt Jones
IT Support Analyst
ITS | [http://www.theitsolution.co.uk/london-it-support-computer-repair/it-support-london.html]IT Support London[/url] | IT Support Chelsea
Jon.Morisi
Jon.Morisi
Ten Centuries
Ten Centuries (1.2K reputation)Ten Centuries (1.2K reputation)Ten Centuries (1.2K reputation)Ten Centuries (1.2K reputation)Ten Centuries (1.2K reputation)Ten Centuries (1.2K reputation)Ten Centuries (1.2K reputation)Ten Centuries (1.2K reputation)

Group: General Forum Members
Points: 1169 Visits: 1142
Could be this again:
http://kb.vmware.com/selfservice/microsites/search.do?language=en_US&cmd=displayKC&externalId=1012225

More info here:
http://jonmorisissqlblog.blogspot.com/2013/04/event-id-7000-sql-serverservice-failed.html
http://www.sqlservercentral.com/Forums/Topic1300021-2799-2.aspx
http://social.msdn.microsoft.com/Forums/en-US/sqlsetupandupgrade/thread/a576aa0e-5a08-4c9c-a583-af1815cd8b8e/
Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum

































































































































































SQLServerCentral


Search