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...
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
Not a clue. Are there errors in the Agent log to show why it won't start? How about in the Windows logs?
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
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
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.
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)
Should be too easy to activate SQLAgent on an Express edition... Let's see I can post the CPU issue at Microsoft
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
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
15 People are following this question.
