Advertisement

10.09.2008 at 05:43AM PDT, ID: 23800590 | Points: 250
[x]
Attachment Details

SQL Server freezes/hangs at 100% utilization durring bakup

Asked by trh9905 in MS SQL Server, SQL Server 2005

The memory suggestion did not help me.  

I am having problems with our SQL server hanging up in my backup process.    I have a deticated Dell SQL 2005 Server (x64) and I am expeiencing the same type of problem.  We are open 24/7 and our production sever can not be down to support a bakup using SQL.  By the same token my client base can not be down as my bakup is finishing.

This is what I have found thus far:
   - The processor utilization spikes at 95+% w/disk utilzation near xero.  It seems like SQL running from memory exclusively.

- This happens near the end of the backup process.  My bckup data is going to the local drive.

- The data on this server is being replicated to another x64 server.

- Performance Toot does not indicate that there is a problem with the SQL Server.

- If I wait 10-12 minutes, perfomance goes back to normal.  It's like SQL is trying to catch up on something that needs to be done using data in memory.

Any suggestions?








 

Start Free Trial
Related Solutions: SQL Server 2005 Locks Up/Freezes during overnight maintenance task
[+][-]10.09.2008 at 05:54AM PDT, ID: 22677789

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 7-day free trial to view this Expert Comment or ask the Experts your question.

 
[+][-]10.09.2008 at 05:55AM PDT, ID: 22677807

Often, when Experts are collaborating with members who have asked questions, they will request additional information about the problem. Askers respond with an author comment like this one.

Start your 7-day free trial to view this Author Comment or ask the Experts your question.

 
[+][-]10.09.2008 at 05:56AM PDT, ID: 22677819

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 7-day free trial to view this Expert Comment or ask the Experts your question.

 
[+][-]10.09.2008 at 06:00AM PDT, ID: 22677850

Often, when Experts are collaborating with members who have asked questions, they will request additional information about the problem. Askers respond with an author comment like this one.

Start your 7-day free trial to view this Author Comment or ask the Experts your question.

 
[+][-]10.09.2008 at 06:02AM PDT, ID: 22677864

Often, when Experts are collaborating with members who have asked questions, they will request additional information about the problem. Askers respond with an author comment like this one.

Start your 7-day free trial to view this Author Comment or ask the Experts your question.

 
[+][-]10.09.2008 at 06:08AM PDT, ID: 22677925

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 7-day free trial to view this Expert Comment or ask the Experts your question.

 
[+][-]10.09.2008 at 06:13AM PDT, ID: 22677968

Often, when Experts are collaborating with members who have asked questions, they will request additional information about the problem. Askers respond with an author comment like this one.

Start your 7-day free trial to view this Author Comment or ask the Experts your question.

 
[+][-]10.09.2008 at 06:16AM PDT, ID: 22678011

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 7-day free trial to view this Expert Comment or ask the Experts your question.

 
[+][-]10.09.2008 at 06:19AM PDT, ID: 22678041

Often, when Experts are collaborating with members who have asked questions, they will request additional information about the problem. Askers respond with an author comment like this one.

Start your 7-day free trial to view this Author Comment or ask the Experts your question.

 
[+][-]10.09.2008 at 06:21AM PDT, ID: 22678056

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 7-day free trial to view this Expert Comment or ask the Experts your question.

 
[+][-]10.09.2008 at 06:28AM PDT, ID: 22678125

Often, when Experts are collaborating with members who have asked questions, they will request additional information about the problem. Askers respond with an author comment like this one.

Start your 7-day free trial to view this Author Comment or ask the Experts your question.

 
[+][-]10.09.2008 at 06:33AM PDT, ID: 22678163

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 7-day free trial to view this Expert Comment or ask the Experts your question.

 
[+][-]10.09.2008 at 06:36AM PDT, ID: 22678200

Often, when Experts are collaborating with members who have asked questions, they will request additional information about the problem. Askers respond with an author comment like this one.

Start your 7-day free trial to view this Author Comment or ask the Experts your question.

 
[+][-]10.09.2008 at 06:38AM PDT, ID: 22678214

Often, when Experts are collaborating with members who have asked questions, they will request additional information about the problem. Askers respond with an author comment like this one.

Start your 7-day free trial to view this Author Comment or ask the Experts your question.

 
 
Loading Advertisement...
20081112-EE-VQP-42 - Hierarchy / EE_QW_Related_20080208