SQL 2000 Query

Posted on 2012-08-13
Last Modified: 2012-08-17
I have a SQL 2000 server that keep hammering the CPU at 80-90%. Is there a query I can run that will tell me exactly what the SQL service is doing at the time of High CPU performance?
Question by:DKHenery
    1 Comment
    LVL 12

    Accepted Solution


    You'll have to use SQL Profiler.

    Can you "make" the CPU spike up? IE. is it doing it when you run XYZ process?
    Does it happen at when you have scheduled your hourly log backups? (usually on the hour perhaps).

    So, the key is to run a trace, wait till you see the 90 to 100 % cpu spike on the the Server Task Manager, then stop the trace and look at the data it has produced....time consuming sorry.

    This article is helpful.

    Featured Post

    What Security Threats Are You Missing?

    Enhance your security with threat intelligence from the web. Get trending threat insights on hackers, exploits, and suspicious IP addresses delivered to your inbox with our free Cyber Daily.

    Join & Write a Comment

    A quick step-by-step overview of installing and configuring Carbonite Server Backup.
    Load balancing is the method of dividing the total amount of work performed by one computer between two or more computers. Its aim is to get more work done in the same amount of time, ensuring that all the users get served faster.
    Using examples as well as descriptions, and references to Books Online, show the documentation available for datatypes, explain the available data types and show how data can be passed into and out of variables.
    Viewers will learn how to use the SELECT statement in SQL to return specific rows and columns, with various degrees of sorting and limits in place.

    755 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

    Need Help in Real-Time?

    Connect with top rated Experts

    19 Experts available now in Live!

    Get 1:1 Help Now