64-bit Server (clustered) 128 GB ram - 155 GB used

It seems the Server itself shows 155GB used, even though one Instance has 91 GB limit and the other 31 GB limit?

The server only has 128 GB of RAM with a 30+ GB Virtual Swap File.

What do I check to see if there is a problem? What perfmon do I use?

We are testing on this server and the CPUs are only at 5-10% max. Some testing brought the CPUs to 80-90%.

There are no errors.

Thanks,

Thomas

If you have two instances on one server, they will use all the memory up to the Max memory limit that you set for SQL Server in each instance.

You also need to make sure that you have given the "Lock Pages in Memory" right to the SQL Server service account. My blog post has more details:

http://glennberrysqlperformance.spaces.live.com/blog/cns!45041418ECCAA960!115.entry

If you are concerned about memory pressure, buffer cache hit ratio and page life expectancy, and memory grants pending are three places to start looking.

|||

Where are you getting the 155GB value from? Can you try DBCC memorystatus on both instances and paste the results?

Thanks, Ron D.

64-bit Server (clustered) 128 GB ram - 155 GB used

It seems the Server itself shows 155GB used, even though one Instance has 91 GB limit and the other 31 GB limit?

The server only has 128 GB of RAM with a 30+ GB Virtual Swap File.

What do I check to see if there is a problem? What perfmon do I use?

We are testing on this server and the CPUs are only at 5-10% max. Some testing brought the CPUs to 80-90%.

There are no errors.

Thanks,

Thomas

If you have two instances on one server, they will use all the memory up to the Max memory limit that you set for SQL Server in each instance.

You also need to make sure that you have given the "Lock Pages in Memory" right to the SQL Server service account. My blog post has more details:

http://glennberrysqlperformance.spaces.live.com/blog/cns!45041418ECCAA960!115.entry

If you are concerned about memory pressure, buffer cache hit ratio and page life expectancy, and memory grants pending are three places to start looking.

|||

Where are you getting the 155GB value from? Can you try DBCC memorystatus on both instances and paste the results?

Thanks, Ron D.

64-bit problem

Hi,
I have an issue with a 64-bit clustered installation that I've just
completed, obviously the management tools can run on the itaniums and
I've put them on a 32-bit server on the same LAN.
My problem concerns creating the full-text indexes that I used to have
on a database. In a nutshell the MMC keeps telling me that the
Full-Text Search service must be running in order to do it (and the
MMC icon does show itself as being RED) but when I click on the
properties for it I get the correct response back that it is really
active. Everything to do with Full-Text is greyed out.
I know that I could script it but ideally I'll like to know if there's
some sort of hack available to make this work properly instead.
Thanks in advance for your help,
Mike
Mike,
Can you post the full output from -- SELECT @.@.version -- from your 64-bit
server? I'm assuming you're using the SQL Server 2000 (64-bit) EE version,
but need to confirm this. Additionally, what account ("System
account"/LocalSystem or DOMAIN\account) are you using for the MSSQLServer
account?
I've some experience with 64-bit SQL Server as I did some benchmarking tests
with Unisys at their lab in L.A. and the MSSearch service was functional,
however I didn't have the time to do FTS testing as we were busy testing
64-bit vs. 32-bit performance comparisons.
Since this is a clustered environment, this issue most likely is related to
either what account you have MSSQLServer running under or perhaps an
installation of the FTS components problem.
Thanks,
John
"Mike" <mike.metcalf@.4projects.com> wrote in message
news:678e073d.0411170818.5ae2e5f3@.posting.google.c om...
> Hi,
> I have an issue with a 64-bit clustered installation that I've just
> completed, obviously the management tools can run on the itaniums and
> I've put them on a 32-bit server on the same LAN.
> My problem concerns creating the full-text indexes that I used to have
> on a database. In a nutshell the MMC keeps telling me that the
> Full-Text Search service must be running in order to do it (and the
> MMC icon does show itself as being RED) but when I click on the
> properties for it I get the correct response back that it is really
> active. Everything to do with Full-Text is greyed out.
> I know that I could script it but ideally I'll like to know if there's
> some sort of hack available to make this work properly instead.
> Thanks in advance for your help,
> Mike
|||Hi John,
it turns out that it was just a blip in the installation and wasnt that
much of a one at that.
It's all working properly now and I for one am really impressed with the
performance increase we're getting across the board.
Thanks for helping,
Mike
*** Sent via Developersdex http://www.codecomments.com ***
Don't just participate in USENET...get rewarded for it!
|||You're welcome, Mike,
Sometimes, all it takes to solve a problem, is to either wait long enough
(for it to solve itself) or reboot! :-)
John
"Mike Metcalf" <mike.metcalf@.4projects.com> wrote in message
news:OBPjpoizEHA.1292@.TK2MSFTNGP10.phx.gbl...
> Hi John,
> it turns out that it was just a blip in the installation and wasnt that
> much of a one at that.
> It's all working properly now and I for one am really impressed with the
> performance increase we're getting across the board.
> Thanks for helping,
> Mike
> *** Sent via Developersdex http://www.codecomments.com ***
> Don't just participate in USENET...get rewarded for it!