Advertisement

04.04.2008 at 12:22PM PDT, ID: 23297108
[x]
Attachment Details

Set Maximum Processor Usage

Asked by jjrr007 in MS SQL Server, SQL Server 2005

We are using MS SQL 2005 at work.  The MS SQL 2005 is installed on a really high end new server (16 processors, TeraBytes of RAM, RAID hard drives etc.)  What we are experiencing is that a couple queries, just take a lot of processor usage. We don't mind the query taking longer, but when the amount of processor usage goes too high, the server freezes.

 We have optimized the queries, but I wanted to ask if there is a way to set the maximum amount of processor usage.  We would like the query to be stopped or take more time, if a query attempts to go over the set amount of processor usage.

At this point, we are only looking at ways to change the configuration of the MS SQL Server and not the queries (the query is already optimized).  Could you please let me know a way to do this?Start Free Trial
[+][-]04.04.2008 at 12:40PM PDT, ID: 21285016

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.

 
[+][-]04.04.2008 at 01:37PM PDT, ID: 21285474

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.

 
[+][-]04.04.2008 at 04:03PM PDT, ID: 21286283

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.

 
[+][-]04.04.2008 at 04:05PM PDT, ID: 21286287

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.

 
[+][-]04.04.2008 at 06:45PM PDT, ID: 21286820

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.

 
[+][-]04.04.2008 at 07:50PM PDT, ID: 21286946

View this solution now by starting your 7-day free trial. Setting up your free trial is quick, easy, and secure. We will return you to this solution, unlocked, when you're done.

 

About this solution

Zones: MS SQL Server, SQL Server 2005
Sign Up Now!
Solution Provided By: bartduncan
Participating Experts: 2
Solution Grade: A
 
 
[+][-]04.08.2008 at 07:34AM PDT, ID: 21305646

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.

 
[+][-]04.08.2008 at 07:50AM PDT, ID: 21305808

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.

 
[+][-]04.08.2008 at 08:20AM PDT, ID: 21306129

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.

 
[+][-]04.08.2008 at 07:22PM PDT, ID: 21311415

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.

 
[+][-]04.09.2008 at 06:55AM PDT, ID: 21314864

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.

 
[+][-]04.09.2008 at 07:28AM PDT, ID: 21315260

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.

 
[+][-]04.09.2008 at 07:42AM PDT, ID: 21315404

Assisted solutions are selected by the member who asked the question as a comment that contributed to their question's solution.

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

 
[+][-]04.09.2008 at 08:22AM PDT, ID: 21315883

Assisted solutions are selected by the member who asked the question as a comment that contributed to their question's solution.

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

 
 
Loading Advertisement...
20080716-EE-VQP-32 / EE_QW_2_20070628