Results 1 to 9 of 9
  1. #1
    Join Date
    Oct 2003
    Posts
    232

    Arrow Unanswered: Cpu Usage 100% On 6.5 Sql

    we have CPU Usage upto almost 100% i increased the tempdb, and master to almost double the size

    then we increased the memory to high amount.


    does anyone have suggestion pls help since it running too slow, since we did an upgrade
    bigfoots

  2. #2
    Join Date
    Nov 2002
    Location
    Jersey
    Posts
    10,322
    Upgrade from what?

    To 6.5?

    Turn on Profiler to see what's going on.

    How's is you r box configured.

    Is SQL the only service on the box?
    Brett
    8-)

    It's a Great Day for America everybody!

    dbforums Yak CorralRadio 'Rita
    dbForums Member List
    I'm Good Once as I ever was

    The physical order of data in a database has no meaning.

  3. #3
    Join Date
    Feb 2004
    Location
    In front of the computer
    Posts
    15,579
    Provided Answers: 54
    Sorry Brett, no profiler on MS-SQL 6.5.

    I'd be interested to know what the hardware/OS/software configuration is. MS-SQL 6.5 would run on a bare-bones Pentium, and maybe even on a 486. Some of those machines had 512 Kb of RAM or less.

    I don't know that we even know enough to ask good questions yet, much less offer suggestions for how to fix the problem(s).

    Is an upgrade to hardware/software less than five years old possible?

    -PatP

  4. #4
    Join Date
    Oct 2003
    Posts
    232

    Arrow

    Sorry for being so incomplete

    I am on window 2000 server running 6.5 sql , had upgraded the vendor application that runs on 6.5 this server ( only thing on box)

    ram 3 gb and server 1.4 mhz with raid drive

    was running well till this upgrade now.

    we increased temp db, master , memory (sql configuration)

    size of database 20 gb
    bigfoots

  5. #5
    Join Date
    Feb 2004
    Location
    In front of the computer
    Posts
    15,579
    Provided Answers: 54
    When you use the NT Task Manager, is SQL Server actually running the CPU wild, or is it only part of your problem?

    There was a known problem prior to sp5 where SQL Server would go mad trying to manage more than 2 Gb of RAM. I assume that you are at sp6, right?

    Try to use sp_who to identify long running tasks, then DBCC INPUTBUFFER to determine what SQL statements those tasks are running.

    -PatP

  6. #6
    Join Date
    Oct 2003
    Posts
    232

    Arrow

    Yes sql is causing the wild ness


    and i taught that 6.5 has only uptill spack 5a

    http://www.microsoft.com/sql/downloads/servicepacks.asp


    My window 2000 server has service pack 4
    bigfoots

  7. #7
    Join Date
    Jan 2003
    Location
    Massachusetts
    Posts
    5,800
    Provided Answers: 11
    You can try to use SQL Trace to catch some of the activity (queries) in the server. SQL Trace is the SQL Profiler ancestor.

    What sort of application is this? Can you take parts of it down to narrow your search? And also, has the vendor said anything like "Oh, yeah. I remember this happened to another client with that setup."

  8. #8
    Join Date
    Oct 2003
    Posts
    232
    It was not tested on 6.5 but on 2000 ,

    Now they are saying
    bigfoots

  9. #9
    Join Date
    Feb 2004
    Location
    In front of the computer
    Posts
    15,579
    Provided Answers: 54
    If SQL-2000 is an option, go there, NOW!

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •