July 15, 2008 at 5:29 am
I think I've tried it before with no luck. The message only appears after installing SP2. I've put the SQL service login account into the policy but I'll have to wait for the next scheduled downtime to reboot and see if it's worked.
July 15, 2008 at 5:36 am
Easy way to check - once you've done the restart, check the first few lines of the error log and see if you have the entry "Using locked pages for buffer pool."
In my server's error log, that was on line 23.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
July 16, 2008 at 10:24 am
to SQLGuru,
can you please provide more info about the iLO driver bug? We've recently had issues with an HP box restarting without ANY errors in any of the logs.
July 17, 2008 at 1:28 am
VD (7/16/2008)
to SQLGuru,can you please provide more info about the iLO driver bug? We've recently had issues with an HP box restarting without ANY errors in any of the logs.
We have the same issue with our HP servers.
These are the first 4 HP servers we are using and all are just quitting at an unpredictable time. :sick:
Non reachable by any means.
The only solution is to push the button, nowadays performed using a certain finger. :Whistling:
Last tuesday our windows system engineer updated all hardware related drives for one box, and now we're keeping our fingers crossed.
For a first impressing of HP stuff, that certainly did not generate sympathy.
Same story goes for the HP support 🙁
Johan
Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data/code to get the best help[/url]
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Need a bit of Powershell? How about this
Who am I ? Sometimes this is me but most of the time this is me
July 18, 2008 at 8:04 am
ALZDBA (7/17/2008)
VD (7/16/2008)
to SQLGuru,can you please provide more info about the iLO driver bug? We've recently had issues with an HP box restarting without ANY errors in any of the logs.
Last tuesday our windows system engineer updated all hardware related drives for one box, and now we're keeping our fingers crossed.
We did a very similar thing - migrated to a box with the latest greatest hardware upgrades. So far we've been up for 5 days (knock on the wood). The original server was becoming unresponsive between every 7-40 hrs. What is really frustrating is that there is absolutely no information in any of the logs that could point us to the reason of why it happens. I should say that we have many HP servers. SO far this has only been happening to 1 of them.
July 18, 2008 at 10:36 am
till today that driver-fixed server has been running fine after the upgrade.
We're planning on doing the same operation on the other 3 servers next tuesday.
No dump, no eventlog, no nothing ... explained easy:
From the boxes view: it becomes unresponsive -> no one uses me
... so you have to push the button .... no reason to dump ... just like with a power loss...
Johan
Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data/code to get the best help[/url]
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Need a bit of Powershell? How about this
Who am I ? Sometimes this is me but most of the time this is me
July 18, 2008 at 11:05 am
GilaMonster (7/15/2008)
Easy way to check - once you've done the restart, check the first few lines of the error log and see if you have the entry "Using locked pages for buffer pool."In my server's error log, that was on line 23.
Gail, would this apply to SQL 2000 as well? I see awe is enabled in my log, and I checked permissions of the account starting SQL Server (it does have "lock pages in memory" but I do not see the message in my log (S2K, sp4). Thanks.
-- You can't be late until you show up.
July 23, 2008 at 2:38 pm
BTW the new drivers are:
HP DL380G5
ComponentFirmwareDriver
Bios P56-01/24/2008-
ILO1.431.13.0.0
Networkcards2.1.2.04.4.21.0
Raidcontroller1.786.12.4.32
Videocard-6.14.10.6744
Johan
Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data/code to get the best help[/url]
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Need a bit of Powershell? How about this
Who am I ? Sometimes this is me but most of the time this is me
July 23, 2008 at 2:50 pm
ALZDBA (7/23/2008)
BTW the new drivers are:
HP DL380G5
ComponentFirmwareDriver
Bios P56-01/24/2008-
ILO1.431.13.0.0
Networkcards2.1.2.04.4.21.0
Raidcontroller1.786.12.4.32
Videocard-6.14.10.6744
Do you have the old drivers by any chance as well? I will ask our sys admin to compare. thank you
July 24, 2008 at 7:17 am
I'm in Toronto this week spending some quality time with the family :w00t:
I'll see if I can get the info you requested.
Johan
Johan
Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data/code to get the best help[/url]
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Need a bit of Powershell? How about this
Who am I ? Sometimes this is me but most of the time this is me
July 25, 2008 at 7:44 am
Hi ,
I am not sure if your problem is solved or not as i dindt have teh patience to read all the replies ;), the Problem description just caught my attention as recently we were facing similiar problem and teh frequency was once in a two weeks when we contacted Microsoft they Gave cu7 but it didnt help much,
but later we found that there was a stored proc which was instatiating a VB DLL and it was creating objects within SQL Server memmory, So when we moved teh DLL to COM+ the problem got solved.
Strange thing was this Procedure was getting fired almost every 30 mins and the crash will happen only every 15 days or so.
If your problem is still exists pls check if sql is calling sp_oacreate through SP.
Regards
Jeswanth
--------------------------------
October 7, 2010 at 1:27 pm
This is a pretty old thread, but just in case someone out there is still looking for a resolution, see http://support.microsoft.com/kb/937343.
Viewing 12 posts - 46 through 56 (of 56 total)
You must be logged in to reply to this topic. Login to reply