Performance Issue

Question

Post reply

Performance Issue

gupta1282

Default port

Points: 1465
More actions
October 8, 2009 at 4:38 am

#156298

Respected All
My server configuration is
Windows server 2003 for small business server having 2 GB RAM
Installed Sql server 2005 Express Editioon
Now I am facing some performance issue
System is hanging.
I verified from task manager , it showing 1-7 % CPU Utilisation , PF Usages 1.8 GB and sqlserver.exe consuming 1.3 GB RAM
I also chcked there is no user connection causing blocking from sp_Who2 and SP_Lock.
Can somebody guide me to solve this issue.
where is problem ?
Thanks & Regards
Ghanshyam

Viewing 9 posts - 1 through 8 (of 8 total)

You must be logged in to reply to this topic. Login to reply

Dave Ballantyne SSC-Dedicated Points: 33667 More actions · Answer 1

Nothing to add since you asked yesterday

http://www.sqlservercentral.com/Forums/Topic798948-360-1.aspx

Clear Sky SQL
My Blog[/url]

Jack Corbett SSC Guru Points: 184394 More actions · Answer 2

Well, you haven't told us what the performance issue is. It looks like it is not something related to CPU, so that leaves it to memory, disk, network, design, or poorly written queries.

Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question

Gail Shaw SSC Guru Points: 1004504 More actions · Answer 3

gupta1282 (10/8/2009)
Can somebody guide me to solve this issue.

Find the slow queries (or the ones consuming lots of CPU). Optimise the queries. This may involve rewriting the code, it may involve tuning the indexes, it usually involves both.

Deploy changes

Repeat until server performance acceptable.

http://www.simple-talk.com/sql/performance/finding-the-causes-of-poor-performance-in-sql-server,-part-1/

http://www.simple-talk.com/sql/performance/finding-the-causes-of-poor-performance-in-sql-server,-part-2/

Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

We walk in the dark places no others will enter
We stand on the bridge and no one may pass

GSquared SSC Guru Points: 260824 More actions · Answer 4

Add more RAM. SQL using 1.3 and page file 1.8 on a 2 Gig machine means you're swapping to disk more than you should be.

I don't even use desktop machines with less than 4 Gig, and servers should definitely have at least that much.

- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread

"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon

Jack Corbett SSC Guru Points: 184394 More actions · Answer 5

GSquared (10/8/2009)
Add more RAM. SQL using 1.3 and page file 1.8 on a 2 Gig machine means you're swapping to disk more than you should be.
I don't even use desktop machines with less than 4 Gig, and servers should definitely have at least that much.

According to the SQL Server 2005 Feature Comparison Sheet Express edition is limited to 1GB of RAM so adding memory shouldn't help SQL Server. Upgrading to Workgroup or Standard edition and adding RAM would help though.

Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question

GSquared SSC Guru Points: 260824 More actions · Answer 6

According to what he posted, it's using 1.3. That plus the swap file data makes it look like a memory pressure issue to me.

Since we're pretty much shooting in the dark here, without anywhere near enough information, I still suggest adding RAM.

- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread

"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon

Jack Corbett SSC Guru Points: 184394 More actions · Answer 7

GSquared (10/8/2009)
According to what he posted, it's using 1.3. That plus the swap file data makes it look like a memory pressure issue to me.
Since we're pretty much shooting in the dark here, without anywhere near enough information, I still suggest adding RAM.

Can't argue with that, but according to MS the Express edition shouldn't be using more that 1GB, so I thought I'd through it out there.

Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question

GSquared SSC Guru Points: 260824 More actions · Answer 8

Jack Corbett (10/8/2009)
GSquared (10/8/2009)
According to what he posted, it's using 1.3. That plus the swap file data makes it look like a memory pressure issue to me.
Since we're pretty much shooting in the dark here, without anywhere near enough information, I still suggest adding RAM.
Can't argue with that, but according to MS the Express edition shouldn't be using more that 1GB, so I thought I'd through it out there.

Makes sense to me.

- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread

"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon