question

Wilfred van Dijk avatar image
Wilfred van Dijk asked

SQLExpress 2012 SP2 issues

I installed SQLExpress 2012 with advanced services on my new Win 8.1 laptop. Since windows update is allowed to update all microsoft products, SP2 was installed also. After the update, i noticed 2 strange things: 1) SQL Agents appears in the configuration manager (not able to start) 2) Reporting about number of logical and physical CPU is changed (screwed up). The laptop has an 'AMD A6-6310 APU with AMD Radeon R4 Graphics' which was identified as 1 physical en 4 logical CPUs. Now it's 0 Physical and 1 logical CPUs. (no bugfix found on CU1) Any ideas? I thought service packs are supported on Express...
sql-agentsql-server-expressservice-packcpu
2 comments
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

OK, after relaxing in the sun in Italy, I reviewed my code and saw the reason for issue 2. So the only thing left is the SQLagent service which was introduced after the deployment of SP2
0 Likes 0 ·
Not a clue. Are there errors in the Agent log to show why it won't start? How about in the Windows logs?
0 Likes 0 ·
Wilfred van Dijk avatar image
Wilfred van Dijk answered
I'm getting confused. Yesterday, I thought I discovered why the logical/physical CPU count was getting wring results (I thought I made a calculation error). However, according to the [microsoft documentation][1], my calculation was ok. This is what I get when querying the 2 columns (including some additional info): ![alt text][2] this is what msinfo32 is reporting: ![alt text][3] [1]: http://msdn.microsoft.com/en-us/library/ms175048.aspx [2]: /storage/temp/1641-capture.png [3]: /storage/temp/1642-capture2.png

capture.png (8.0 KiB)
capture2.png (8.0 KiB)
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Wilfred van Dijk avatar image
Wilfred van Dijk answered
I was able to start the SQLAgent service, however it stopped before the progress indicator was at the end. It did create a SQLAgent errorlog: ![alt text][1] [1]: /storage/temp/1645-agentstart.png

agentstart.png (29.1 KiB)
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Grant Fritchey avatar image
Grant Fritchey answered
Looks like you have the Agent running under an account that doesn't have access to the server. I'd suggest changing it to a different login in the Configuration Manager.
3 comments
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

yes, but it's sqlEXPRESS, which shouldn't have a SQLAgent .... However, I tried to change the logon to LocalSystem, which leads to "the proces terminated unexpectedly" when I clicked on Apply (not when starting the service)
0 Likes 0 ·
That might not work at all then.
0 Likes 0 ·
Should be too easy to activate SQLAgent on an Express edition... Let's see I can post the CPU issue at Microsoft
0 Likes 0 ·
Wilfred van Dijk avatar image
Wilfred van Dijk answered
FYI: answer on microsoft forum below. Seems this CPU is a stacked physical CPU in 1 socket. Wilfred, Just for your information, the sys.dm_os_sys_info DMV is not always correct for those columns. [For Example][1]. Your processor is an A6-6310 which is a single socket with 4 physical cores. It does NOT support hyper threading, so all cores are physical execution units and not logical execution units. Since it doesn't support hyper-threading the physical cores were stuffed in that column. You have 4 processors on a single socket, the DMV and SSMS are correct. Sean Gallardy | Blog | Microsoft Certified Master [1]: https://connect.microsoft.com/SQLServer/feedbackdetail/view/657435
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Wilfred van Dijk avatar image
Wilfred van Dijk answered
The story continues! I also installes SQL2014 RTM Developer on the same laptop as SQL2012 Express SP2. Guess what? ![alt text][1] [1]: /storage/temp/1667-capture.png

capture.png (9.0 KiB)
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.