Hi,

  Thank you for all the help to resolve the issue. It's just I tried everything to monitor why sql server hogs to 100%. I just installed service pack 1...

hi,

  I am trying to play with other options to find why the cpu goes to 100%. As far as this table that i set fill factor of 70 has...

HI,

 What I understood that when there is lots of inserts on table, set the fill factor of 70%.  I don't query anything from the table..this is just audit table and...

I have windows 2003 and installed the sql 2005 enterprise..

I have configured the sql server configuration manager to allow tcp/ip and named piple connection. 

I have virsus scan but it...

I checked the task manager to see if it was running any other services and occupying the cpu. it's not. This is where i checked first and then checked the...

HI,

  I have ran sp_who2 but i don't see any high cpu hold for any spid.  I just found that i don't have installed the service pack 1. if you...

Hi,

 I ran sp_who2 stored procedure and also checked the task manager to see what causing the cpu high. I ran sql profile to see if any spid causing the cpu...

Has anyone use this commnd?

osql -E -S "<serverName> ,1433

hi,

thanks, I found the article. I wanted to know more about fill factor. I have table which is heavily for inserting rows.  I wanted to use fill factor on...

Hi,

  I have about 1gig memory occupied to sql server for only this reason. however, i was searching regarding this error message and found it from microsoft forum that, it...

hi,

 thanks for reply.  I ran sp_who2 stored procedure but i don't see it anything running for a long time. yeah, I have users makes connection but not doing anything. It's...

Hi, I just reply but actually added to my post.