Click here to monitor SSC
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


SQL Server 2005 Ghost in the Machine


SQL Server 2005 Ghost in the Machine

Author
Message
Robert Johnson-480306
Robert Johnson-480306
SSC Rookie
SSC Rookie (39 reputation)SSC Rookie (39 reputation)SSC Rookie (39 reputation)SSC Rookie (39 reputation)SSC Rookie (39 reputation)SSC Rookie (39 reputation)SSC Rookie (39 reputation)SSC Rookie (39 reputation)

Group: General Forum Members
Points: 39 Visits: 326
Gotta serious ghost in the machine here. I upgraded our dev sql server box from a 1 dual core, 2 gb ram, 1 Raid 5 disk volume to 2 Quad core, 8 gb RAM, 2 RAID 10 Disk volume. Needless to say, it screamed on the new box. About 20 developers were very happy. I am using SQL server 2005 SP2 with Cumulative Service pack 9. Still sounds good? Worked fine on other machines.

So we run with it for the day. About noon, it completely freezes up.

Restart, no biggie.

Check the sql server logs, nothing but one statement saying it is taking a while to retrieve data from MDF file. It then says that windows has requested a shutdown, which we had requested. Nothing at all in the windows event log... Still no biggie.

Run for 2 hours, screaming fast. Developers are in love with SQL Server all over again. I am walking tall.

FREEZE...

Check the sql server logs, nothing but one statement saying it is taking a while to retrieve data from A DIFFERENT MDF file. It then says that windows has requested a shutdown, which we had requested. Nothing at all in the windows event log... Still no biggie.

This freeze starts to happen spurodically throughout the day.

We pull memory, nothing.

We did find that if we shut down Sql Server Agent (3 instances), it won't fail; however, the jobs are pretty big with a few SISS packages scheduled throughout the day. NO BIGGIE.

My sysadmin tells me its SQL server. I am convinced that it isn't; however, you never know and I have seem some weird stuff happen over the years that puzzle me.

I decide I am going to completely un-install SQL-SERVER and install it back. I also am going to drop down to Cumulative Pack 7 (figure 2 back is better than 1).

Fingers crossed...

FREEZE...

I am now convinced that our jobs are the ignition, but not the bomb. Sysadmin feels differently.

Anyone experience something like this or at least can point us in the right direction? We moved this instance from an old server and renamed this to the old server name so that App connections need not change; however, I did notice that our sysadmin forgot to change the name (sp_dropserver,sp_addserver) of the old server. Would that cause this Ghost?

Truly,
Bobby Johnson
(ignore the tone and grammatical errors, its been a very long weekend)
Steve Jones
Steve Jones
SSC-Dedicated
SSC-Dedicated (36K reputation)SSC-Dedicated (36K reputation)SSC-Dedicated (36K reputation)SSC-Dedicated (36K reputation)SSC-Dedicated (36K reputation)SSC-Dedicated (36K reputation)SSC-Dedicated (36K reputation)SSC-Dedicated (36K reputation)

Group: Administrators
Points: 36008 Visits: 18728
This is almost always hardware. Freezing like this could be bad hardware, strange drivers, anything like that.

Follow me on Twitter: @way0utwest
Forum Etiquette: How to post data/code on a forum to get the best help
My Blog: www.voiceofthedba.com
free_mascot
free_mascot
SSCrazy
SSCrazy (2.9K reputation)SSCrazy (2.9K reputation)SSCrazy (2.9K reputation)SSCrazy (2.9K reputation)SSCrazy (2.9K reputation)SSCrazy (2.9K reputation)SSCrazy (2.9K reputation)SSCrazy (2.9K reputation)

Group: General Forum Members
Points: 2879 Visits: 2235
Robert,

In deed looks very strange.

Does your new SQL Server installation goes well without any problem? Have you created test DB and test?

If new installation is working fine:

As you mention it's having problem in finding MDF file; hence I suggest you to detach and attach the user as well as system DB. Hope should work fine.

Also from other computer start SQL Profiler to fetch any error which might give you more visibility.

Good Luck!!!
FM

---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
Robert Johnson-480306
Robert Johnson-480306
SSC Rookie
SSC Rookie (39 reputation)SSC Rookie (39 reputation)SSC Rookie (39 reputation)SSC Rookie (39 reputation)SSC Rookie (39 reputation)SSC Rookie (39 reputation)SSC Rookie (39 reputation)SSC Rookie (39 reputation)

Group: General Forum Members
Points: 39 Visits: 326
I think it is hardware. We are sending it to IBM today.
Robert Johnson-480306
Robert Johnson-480306
SSC Rookie
SSC Rookie (39 reputation)SSC Rookie (39 reputation)SSC Rookie (39 reputation)SSC Rookie (39 reputation)SSC Rookie (39 reputation)SSC Rookie (39 reputation)SSC Rookie (39 reputation)SSC Rookie (39 reputation)

Group: General Forum Members
Points: 39 Visits: 326
I did all that you mentioned above. Profiled, etc... Nothing that says it DB.
Jerry Hung
Jerry Hung
Right there with Babe
Right there with Babe (792 reputation)Right there with Babe (792 reputation)Right there with Babe (792 reputation)Right there with Babe (792 reputation)Right there with Babe (792 reputation)Right there with Babe (792 reputation)Right there with Babe (792 reputation)Right there with Babe (792 reputation)

Group: General Forum Members
Points: 792 Visits: 1208
Does the new box freeze without SQL Server installed or running?

My bet is hardware too, but that's what every DBA likes to say Smile

SQLServerNewbie

MCITP: Database Administrator SQL Server 2005
MVDBA
MVDBA
SSCrazy
SSCrazy (2.4K reputation)SSCrazy (2.4K reputation)SSCrazy (2.4K reputation)SSCrazy (2.4K reputation)SSCrazy (2.4K reputation)SSCrazy (2.4K reputation)SSCrazy (2.4K reputation)SSCrazy (2.4K reputation)

Group: General Forum Members
Points: 2421 Visits: 860
just out of interest - you upgraded from 2gb of ram to 8gb - did you set /3GB and /PAE in your boot.ini. if so did you do sp_configure 'awe enabled',1 - finally what did you set as the max mem.


maybe i'm barking up the wrong tree though...

MVDBA
FNS
FNS
SSC-Enthusiastic
SSC-Enthusiastic (109 reputation)SSC-Enthusiastic (109 reputation)SSC-Enthusiastic (109 reputation)SSC-Enthusiastic (109 reputation)SSC-Enthusiastic (109 reputation)SSC-Enthusiastic (109 reputation)SSC-Enthusiastic (109 reputation)SSC-Enthusiastic (109 reputation)

Group: General Forum Members
Points: 109 Visits: 584
michael vessey (11/18/2008)
finally what did you set as the max mem.
maybe i'm barking up the wrong tree though...


I've seen SQL servers do this before and it has (as others suggested) been hardware. A memory fault which is only "discovered" as SQL starts to eat its way up through the new RAM (to its max setting). When first started it may only need about 2Gb, then as users hammer away it decides another 2Gb would be good and so on. Then it hits the fault and pukes.

Of course if you're running multiple instances and haven't limited the max RAM they can have... Wink
free_mascot
free_mascot
SSCrazy
SSCrazy (2.9K reputation)SSCrazy (2.9K reputation)SSCrazy (2.9K reputation)SSCrazy (2.9K reputation)SSCrazy (2.9K reputation)SSCrazy (2.9K reputation)SSCrazy (2.9K reputation)SSCrazy (2.9K reputation)

Group: General Forum Members
Points: 2879 Visits: 2235
I fully agreed with FNS.

As I have experience the same thing in my environment. As soon as wintel teams reboot the server works fine and after while again sink. Sad

---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
Robert Johnson-480306
Robert Johnson-480306
SSC Rookie
SSC Rookie (39 reputation)SSC Rookie (39 reputation)SSC Rookie (39 reputation)SSC Rookie (39 reputation)SSC Rookie (39 reputation)SSC Rookie (39 reputation)SSC Rookie (39 reputation)SSC Rookie (39 reputation)

Group: General Forum Members
Points: 39 Visits: 326
It will freeze when the SQL Agent is running (which has a massive amount of SQL server jobs)
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