SQL Server 2005 Express CPU usage too high??

Hot Topic

Having Problem With installation
profiler can't save trace to file
Business Intelligence Development Studio not installing from Toolkit
Processing cubes in Analysis Services 2000
User-Defined Datatypes based on abstract classes
SSIS Requests...
How can I skip an initialize snapshot?
Connect MS SQL Server to UniData tables
Performance, handling 1.2 million rows takes 7-8 hours?
Calculated Members slow to display in Excel PivotTable

SQL Server

CREATE CERTIFICATE from backup: error message
run code
warning while installing ms sql server 2005CTP
SQLMobile install help
Management Studio for SQL Server 2005 Standard
Report Model as datasource in ordinary report
Error "Msg 6522, Level 16, State 1" receives when call the assembly from Store Procedure to create a Text file and to Write text
Database restore to new database
create tables and insert data in sql server mobile on dekstop
prorating the date fields with cost

SQL Server 2005 Express CPU usage too high??

I have a website with about 130,000 page views per day, I'm using a P4 2.8G/1GB RAM dedicated server for database. When I upgraded my database to SQL Server 2005 Express, I noticed the CPU usage goes too high, sometimes the CPU usage goes to 100%. My database table only has about 25K records.
My questions is how to optimize my database Is there any tips to do that


Answer this question

SQL Server 2005 Express CPU usage too high??

  • Rakesh Kumar V.V. from Pampady

    start by getting a trace profile to see which statements are taking up the most time in terms of Duration, CPU and Reads. Then look at the plan.

  • John H.

    try downloading the trial software

  • Mike S

    I'm using SQL Server 2005 Express Edition, it does not contain the SQL Profiler Tool. Is it possible to download it separately

  • UllaH

    What did you search for that couldn't get you the information

    Anyways, use Profiler tool, or use TSQL.

    http://lab.msdn.microsoft.com/search/ query=sql+server+trace+profiler

  • Merav

    Thank you for your reply!
    Could you please tell me how to getting a trace profile Do I need a third-party software I just did a search but without an answer.


  • SQL Server 2005 Express CPU usage too high??
Answer this question