[Webinar] Streamline your web hosting managementRegister Today

x
?
Solved

When running reports through SQL cpu goes to 100%  for the duration of the report. Pos 2 mins

Posted on 2008-02-06
2
Medium Priority
?
233 Views
Last Modified: 2010-04-19
We have a SBS 2003 Premium running the SBS SQL Server. Everything on the server works fine except when we come to print reports through the SQL database. As soon as we do the CPU goes to 100% and stays there for the duration of the time required to gather the information to produce the report which can be anything up to 3-4 mins during which time everybody and everthing else grinds to a halt.

The spec of the server is  a Pentium 4 - 2.8 with 4 gb of ram & 2 X 160 GB HD'S configured as RAID 1 on an Adaptec controller.
0
Comment
Question by:catsystems
2 Comments
 
LVL 25

Accepted Solution

by:
slam69 earned 1000 total points
ID: 20833576
the query that is pulling the sql reqort does it entail peforming a full table scan or is it an indexed scan. if it is a table scan then this is why you are seein gthe large query time especially if it is a large table.
0
 

Author Comment

by:catsystems
ID: 21271064
Sorry about the delay in comming back but your solution worked... many thanks
0

Featured Post

Take Control of Web Hosting For Your Clients

As a web developer or IT admin, successfully managing multiple client accounts can be challenging. In this webinar we will look at the tools provided by Media Temple and Plesk to make managing your clients’ hosting easier.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

In part one, we reviewed the prerequisites required for installing SQL Server vNext. In this part we will explore how to install Microsoft's SQL Server on Ubuntu 16.04.
There are literally thousands of Exchange recovery applications out there. So how do you end up picking one that’s ideal for your business & purpose? By carefully scouting the product’s features, the benefits it offers you, & reading ample reviews f…
Via a live example, show how to backup a database, simulate a failure backup the tail of the database transaction log and perform the restore.
Viewers will learn how the fundamental information of how to create a table.
Suggested Courses

612 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question