General discussion

Locked

How to interpret perfomance monitor

By MtnSqs ·
I am hoping someone can help me.

I have a NT server (BDC) which is supporting a number of applications incluign our Intranet, Clearquest (accessed via intranet and uses an SQL 7 Db ), A sybase datbase system for our timesheets, Exchange 5.5 and storage for our PVCS source code control system.

The box is running very slow - I am blaming clearquest as it was ok until this was added a ew months ago.

When looking at taskmanager I see two copies of sqlsvr.exe running - anyone know why?Also a program called STORE.EXE is taking up huge amount of memory - any one know whatthis is??

I've been running performance moniter on process, committed bytes and page faults - seems to be a lot of time when committed bytes are 100%, although% in use is running at about 50% We also get lots of page fault activity - sometime goes up to 4000 or 5000 per sec??

Does any one have any ideas on what this mught be, or where can I get useful info on what to monite and how to interpret the results?

This conversation is currently closed to new comments.

5 total posts (Page 1 of 1)  
| Thread display: Collapse - | Expand +

All Comments

Collapse -

How to interpret perfomance monitor

by daniel_macnish In reply to How to interpret perfoma ...

Store.exe is the Exchange information store, and it is well known to grab every last bit of memory available. The excessive paging seems to indicate that you don't have enough memory in the server. You can optimise the amount of memory that SQL server will use (see http://support.microsoft.com/support/ServiceWare/SQL/SQL70/EAFGB6M4S.ASP) and see if this helps. Otherwise, add more memory to the server, or, preferably, move Exchange to its own server.

Collapse -

How to interpret perfomance monitor

by MtnSqs In reply to How to interpret perfoma ...

Poster rated this answer

Collapse -

How to interpret perfomance monitor

by McKayTech In reply to How to interpret perfoma ...

Very likely, the short answer is that you're short on RAM. Very short...although I don't know how much you have so I can't make a recommendation on where to go from here. However, with what you have running, a full gig of RAM wouldn't be too much.

The first answer is correct in regards to STORE.EXE - it will take up as much memory as is available unless you tell it otherwise. You can do so by running the Exchange Optimizer and setting a limit on the amount of memory used by Exchange.

It is also possible that you could restrict the amount of RAM available to SQL Server and maybe even things out a little. It sounds like it was the installation of the SQL database that pushed things over the edge and that would not be an unusual event as it, like Exchange, is very RAM intensive.

Probably the best reference I can give you to sort out these parameters is an article on Microsoft's TechNet (#Q146005).

regards!

paul

Collapse -

How to interpret perfomance monitor

by MtnSqs In reply to How to interpret perfoma ...

Poster rated this answer

Collapse -

How to interpret perfomance monitor

by MtnSqs In reply to How to interpret perfoma ...

This question was closed by the author

Back to Windows Forum
5 total posts (Page 1 of 1)  

Related Discussions

Related Forums