Viewing 15 posts - 1 through 15 (of 21 total)
No joy for me either - why do Microsoft tie us up in knots at times...
January 16, 2013 at 10:52 am
That sounds promising - i'll try that see if it does the trick 🙂
January 16, 2013 at 10:09 am
Gail if i was a little unclear.
Both the paging counters were selected from the 'memory' performance object.
December 18, 2012 at 4:11 am
It's this version
Microsoft SQL Server 2005 - 9.00.5057.00 (Intel X86) Mar 25 2011 13:50:04 Copyright (c) 1988-2005 Microsoft Corporation Enterprise Edition on Windows NT...
December 18, 2012 at 3:33 am
Whilst i was in perform i noticed the pages/sec was quite spiky with peaks of around 1500/sec.
Is this on the high side or normal server performance ?
December 18, 2012 at 3:12 am
Thanks Gail - it's showing as 4194304 (ie 4Gb) in perfmon
The instance has AWE enabled, is the view this is better to have on than off ?
December 18, 2012 at 2:55 am
Thanks Gail - what's the recommended way ?
December 17, 2012 at 11:25 am
Incredibly this was linked to the server having NOT been rebooted adter i was given assurances it would be rebooted at the weekend just gone...
Moral of the story i guess...
November 27, 2012 at 10:25 am
John Mitchell-245523 (11/27/2012)
Sounds like you need to grant the service account the lock pages in memory right.John
Be lovely if it was that easy John 😀 we granted this in group...
November 27, 2012 at 5:52 am
John Mitchell-245523 (11/27/2012)
MikeWhere are those messages appearing? Are you getting anything in SQLAGENT.OUT?
John
Cheers John - here it is
2012-11-27 10:19:02 - ! [298] SQLServer Error: 5845, Address Windowing Extensions (AWE)...
November 27, 2012 at 3:45 am
Hi,
Here are the informational messages arriving before the error - not sure if these are red herrings or not.
SQL Server blocked access to procedure 'dbo.sp_sqlagent_has_server_access' of component 'Agent XPs' because...
November 27, 2012 at 3:25 am
We have a test system that's pretty much a clone of this live system.
On this node i did nothing more than add the service account to the sqlagent group and...
November 27, 2012 at 2:31 am
John Mitchell-245523 (11/26/2012)
November 26, 2012 at 8:12 am
Sorry John i'm not quite sure what you are saying there ?
The service account does have a login to the instance already with sysadmin role.
November 26, 2012 at 7:14 am
John Mitchell-245523 (11/26/2012)
It sounds as if you didn't use SQL Server Configuration Manager to make the change. Maybe you used the Services applet instead? Try using SQL Server...
November 26, 2012 at 6:58 am
Viewing 15 posts - 1 through 15 (of 21 total)