SQL Server working very slow - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2005 Forums

SQL Server Administration (2005)

SQL Server working very slow

Author

Topic

navnath21
Starting Member

4 Posts

Posted - 2011-09-26 : 05:24:45

Hi friends, I am using SQL SERVER 2005 in my office.

It's working very slow in network & also the same system takes too much processing for sql 2005.

Please suggest

Navnath Kad,
Pune

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2011-09-26 : 05:34:13

check the amount of RAM and CPU sql server application is using in task manager

------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/

RickD
Slow But Sure Yak Herding Master

3608 Posts

Posted - 2011-09-26 : 05:35:26

Put it on a faster machine, maintain it properly etc..

Seriously, do you expect us to be able to help with this level of information? Please provide much more and there may be a possibility we could help you.

senthil_nagore
Master Smack Fu Yak Hacker

1007 Posts

Posted - 2011-09-26 : 05:37:51

Use Perfmon to monitor the SQL Instance..

Start>run>perfmon

Senthil.C
------------------------------------------------------
[Microsoft][ODBC SQL Server Driver]Operation canceled

http://senthilnagore.blogspot.com/

navnath21
Starting Member

4 Posts

Posted - 2011-09-26 : 06:21:19

quote:
Originally posted by visakh16

check the amount of RAM and CPU sql server application is using in task manager

------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/

I am using C2D Machine With 4GB Of RAM
And the os is windows server 2003 R2.

Whenever I restart the machine, SQL Works properly for 10 to 15 min and then after It gets slow down.. and takes max usage for sql.

Navnath Kad,
Pune

navnath21
Starting Member

4 Posts

Posted - 2011-09-26 : 06:21:46

quote:
Originally posted by navnath21

quote:
Originally posted by visakh16

check the amount of RAM and CPU sql server application is using in task manager

------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/

I am using C2D Machine With 4GB Of RAM
And the os is windows server 2003 R2.

Whenever I restart the machine, SQL Works properly for 10 to 15 min and then after It gets slow down.. and takes max usage for sql

I am using C2D Machine With 4GB Of RAM
And the os is windows server 2003 R2.

Whenever I restart the machine, SQL Works properly for 10 to 15 min and then after It gets slow down.. and takes max usage for sql.

Navnath Kad,
Pune

Navnath Kad,
Pune

senthil_nagore
Master Smack Fu Yak Hacker

1007 Posts

Posted - 2011-09-26 : 06:27:02

quote:
Originally posted by navnath21

quote:
Originally posted by visakh16

check the amount of RAM and CPU sql server application is using in task manager

------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/

I am using C2D Machine With 4GB Of RAM
And the os is windows server 2003 R2.

Whenever I restart the machine, SQL Works properly for 10 to 15 min and then after It gets slow down.. and takes max usage for sql.

Navnath Kad,
Pune

Run the Perfmon and check which component use more resources(cpu/memory/IO)

Senthil.C
------------------------------------------------------
MCTS - [Microsoft][ODBC SQL Server Driver]Operation canceled

navnath21
Starting Member

4 Posts

Posted - 2011-09-26 : 07:41:12

quote:
Originally posted by senthil_nagore

quote:
Originally posted by navnath21

quote:
Originally posted by visakh16

check the amount of RAM and CPU sql server application is using in task manager

------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/

It takes time for network services, up to 40 to 65 % I have Changes the lan card also. but no results.

Is it required any update for windows or the sql updates?

I am using C2D Machine With 4GB Of RAM
And the os is windows server 2003 R2.

Whenever I restart the machine, SQL Works properly for 10 to 15 min and then after It gets slow down.. and takes max usage for sql.

Navnath Kad,
Pune

Run the Perfmon and check which component use more resources(cpu/memory/IO)

Senthil.C
------------------------------------------------------
MCTS - [Microsoft][ODBC SQL Server Driver]Operation canceled

Navnath Kad,
Pune

Kristen
Test

22859 Posts

Posted - 2011-09-26 : 08:19:17

"Whenever I restart the machine, SQL Works properly for 10 to 15 min and then after It gets slow down.. and takes max usage for sql"

My guesses are:

1) Your queries are not well optimised
2) You are using dynamic, non-parameterised, SQL which is flooding the query cache with one-off query plans
3) You have databases which are much larger than the installed RAM can handle
4) Adhoc Statistics Update is called regularly to try to get better statistics for the queries it is being asked to process (optimising them may well solve that)

If you don't know how to solve this get a consultant in. If you have weeks / months to spend learning how to solve it then you will have learnt some very good skills - but you won't be able to fix the problem until you have learnt enough to be able to make a difference. Sitting alongside a consultant and watching what they do will give you some speedy-education, which will be useful to you and your company after the consultant has gone.

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources