SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


Memory Utilization is very low 13.8 GB out of 20 GB


Memory Utilization is very low 13.8 GB out of 20 GB

Author
Message
Alone
Alone
SSC Rookie
SSC Rookie (45 reputation)SSC Rookie (45 reputation)SSC Rookie (45 reputation)SSC Rookie (45 reputation)SSC Rookie (45 reputation)SSC Rookie (45 reputation)SSC Rookie (45 reputation)SSC Rookie (45 reputation)

Group: General Forum Members
Points: 45 Visits: 287
Everyday I experience block in the database but checked query plan is ok ,all indexes already in place,no fragmentation issue..

When i was looking into memory some thing is wrong:

This a SQL dedicated server,it has sqlserver 2000 ent edition 32 bit installed

Total memory: 25 GB
max memory setting--20 GB
But sql always using only 13.8 GB.AWE is enabled.Should i migrate to SQLSERVER 2000 ent 64 bit.
I can't migrate 2005/2008 as application won't support..

Pls suggest..
GilaMonster
GilaMonster
SSC Guru
SSC Guru (90K reputation)SSC Guru (90K reputation)SSC Guru (90K reputation)SSC Guru (90K reputation)SSC Guru (90K reputation)SSC Guru (90K reputation)SSC Guru (90K reputation)SSC Guru (90K reputation)

Group: General Forum Members
Points: 90603 Visits: 45284
The only 64-bit version of SQL 2000 is the Itanium, and I doubt you have one of those lying around, or want one for that matter.

Is there actually a problem resulting from the low memory?

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


Alone
Alone
SSC Rookie
SSC Rookie (45 reputation)SSC Rookie (45 reputation)SSC Rookie (45 reputation)SSC Rookie (45 reputation)SSC Rookie (45 reputation)SSC Rookie (45 reputation)SSC Rookie (45 reputation)SSC Rookie (45 reputation)

Group: General Forum Members
Points: 45 Visits: 287
I am not sure whether there in any memory issue but i can see SQL only using 13.8 GB memory constantly but i have configured max memory 20GB.

I was suggested if i can use sqlserver 2000 EE 64 bit the issue could be solved.

Please suggest how can i confirmed what the actual issue.I can see daily 6/7 times temp blocking occurred.
GilaMonster
GilaMonster
SSC Guru
SSC Guru (90K reputation)SSC Guru (90K reputation)SSC Guru (90K reputation)SSC Guru (90K reputation)SSC Guru (90K reputation)SSC Guru (90K reputation)SSC Guru (90K reputation)SSC Guru (90K reputation)

Group: General Forum Members
Points: 90603 Visits: 45284
Alone (11/12/2011)
I am not sure whether there in any memory issue but i can see SQL only using 13.8 GB memory constantly but i have configured max memory 20GB.


Ok, again, is that a problem? Are you seeing signs of memory pressure in SQL Server?

I was suggested if i can use sqlserver 2000 EE 64 bit the issue could be solved.


If you bought an Itanium server. SQL 2000 does not have an x64 version, only IA64. It's a completely different processor architecture and, as far as I know, they've been discontinued for a few years.

I can see daily 6/7 times temp blocking occurred.


Which may or maynot, but probably doesn't, have anything to do with memory. Blocking is often poor indexing or poor code.

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


Alone
Alone
SSC Rookie
SSC Rookie (45 reputation)SSC Rookie (45 reputation)SSC Rookie (45 reputation)SSC Rookie (45 reputation)SSC Rookie (45 reputation)SSC Rookie (45 reputation)SSC Rookie (45 reputation)SSC Rookie (45 reputation)

Group: General Forum Members
Points: 45 Visits: 287
Thanks for this information.

Main issue is slowness and when ever slowness occurs i see temp block in databases ,so when i kill the culprit blocker the issue resolved.I was able to trace culprit stored procedure but it is tuned.

How to check memory pressure?
GilaMonster
GilaMonster
SSC Guru
SSC Guru (90K reputation)SSC Guru (90K reputation)SSC Guru (90K reputation)SSC Guru (90K reputation)SSC Guru (90K reputation)SSC Guru (90K reputation)SSC Guru (90K reputation)SSC Guru (90K reputation)

Group: General Forum Members
Points: 90603 Visits: 45284
If it's causing blocking, it's probably not tuned.

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/

or http://www.sqlservercentral.com/articles/SQLServerCentral/66909/

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


Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum

































































































































































SQLServerCentral


Search