Sqlsrver.exe at 100%

[ryanropp]

Not sure if this is the right place for this or if I even know enough about sql to ask this, however, I'm going to try anyway.

We have a citrix server running software that uses msde and not full sql. Whenever we run a specific report, it always gives us "Error Processing report: Timeout expired". The software we are using is for property management and we currently have 5 properties. The report runs fine on the smaller properties but always hangs and gives the above error on the larger ones. I opened task manager and noticed that the sqlsrver.exe process was taking up 100% of the processor.

The server we are using is a P3 1.2ghz with 10k scsi's and 1gb of ram. At any given time, we have about 6 people connected via citrix. The OS is windows server 2000, service pack 4.

Can anyone tell me where to start on this?

Thanks

 

[SQLDenis]

Run perfmon and determine what is causing this



“I sense many useless updates in you... Useless updates lead to defragmentation... Defragmentation leads to downtime...Downtime leads to suffering..Defragmentation is the path to the darkside.. DBCC INDEXDEFRAG and DBCC DBREINDEX are the force...May the force be with you" --

http://sqlservercode.blogspot.com/

 

[mrdenny]

If the query that the report is very complex and there is lots of data involved the query may make longer than the report allows for to complete.

You'll want to use SQL Profiler to find out what the query is and what the execution plan is. From there you can detumin what the indexes are and if any new indexes need to be created.

Denny
MCSA (2003) / MCDBA (SQL 2000)

--Anything is possible. All it takes is a little research. (Me)

http://www.mrdenny.com

 

[gmmastros]

Please run

Select @@Version

Post the result back here.

Mr. Denny posted a link to this site a little while ago. After determining your service pack level, go to this site.

http://www.sqlsecurity.com/DesktopDefault.aspx?tabid=37

You will see what the numbers reported by Enterprise Manager really mean.



-George

Strong and bitter words indicate a weak cause. - Fortune cookie wisdom