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


4 database instances in a single server (SQL Server 2005)


4 database instances in a single server (SQL Server 2005)

Author
Message
chewychewy
chewychewy
SSC Veteran
SSC Veteran (240 reputation)SSC Veteran (240 reputation)SSC Veteran (240 reputation)SSC Veteran (240 reputation)SSC Veteran (240 reputation)SSC Veteran (240 reputation)SSC Veteran (240 reputation)SSC Veteran (240 reputation)

Group: General Forum Members
Points: 240 Visits: 520
Hi Guys,
I have 4 database instances (2005) running in a single server.
How am i able to know how much memory each database instance is using?

thanks!
SQLRNNR
SQLRNNR
SSC-Dedicated
SSC-Dedicated (32K reputation)SSC-Dedicated (32K reputation)SSC-Dedicated (32K reputation)SSC-Dedicated (32K reputation)SSC-Dedicated (32K reputation)SSC-Dedicated (32K reputation)SSC-Dedicated (32K reputation)SSC-Dedicated (32K reputation)

Group: General Forum Members
Points: 32715 Visits: 18559
Perfmon has counters by the instance. You can load up memory counters by instance in perfmon to track mem usage.



Jason AKA CirqueDeSQLeil
I have given a name to my pain...
MCM SQL Server, MVP


SQL RNNR

Posting Performance Based Questions - Gail Shaw

chewychewy
chewychewy
SSC Veteran
SSC Veteran (240 reputation)SSC Veteran (240 reputation)SSC Veteran (240 reputation)SSC Veteran (240 reputation)SSC Veteran (240 reputation)SSC Veteran (240 reputation)SSC Veteran (240 reputation)SSC Veteran (240 reputation)

Group: General Forum Members
Points: 240 Visits: 520
Hi,

thanks. Is it something like total server memory and target server memory in buffer manager?

Which should take? Total or Target?

thanks!
Orlando Colamatteo
Orlando Colamatteo
SSCoach
SSCoach (15K reputation)SSCoach (15K reputation)SSCoach (15K reputation)SSCoach (15K reputation)SSCoach (15K reputation)SSCoach (15K reputation)SSCoach (15K reputation)SSCoach (15K reputation)

Group: General Forum Members
Points: 15035 Visits: 14396
Look for SQL Server:Memory Manager (as MSSQL$InstanceName:Memory Manager) counters:

- Target Server Memory (KB) is how much memory the instance would want to use if the demand was there from active processes and the memory were available.
- Total Server Memory (KB) is how much memory the instance actually is using at the moment.

Once the buffer pool is warmed up those numbers will generally be the same, but immediately after a restart, or if demand for data never reaches the capabilities of the server memory, Target will be lower than Total.

See Page 153 of Troubleshooting SQL Server: A Guide for the Accidental DBA for more info.

__________________________________________________________________________________________________
There are no special teachers of virtue, because virtue is taught by the whole community. --Plato
SQLRNNR
SQLRNNR
SSC-Dedicated
SSC-Dedicated (32K reputation)SSC-Dedicated (32K reputation)SSC-Dedicated (32K reputation)SSC-Dedicated (32K reputation)SSC-Dedicated (32K reputation)SSC-Dedicated (32K reputation)SSC-Dedicated (32K reputation)SSC-Dedicated (32K reputation)

Group: General Forum Members
Points: 32715 Visits: 18559
Here is a quick query to see the internal "point in time" memory clerk use for the sql instance


SELECT @@servername AS InstanceName,SUM(single_pages_kb)/1024 AS [SPA Mem, Mb]
FROM sys.dm_os_memory_clerks
ORDER BY [SPA Mem, Mb] DESC



You would need to run this against each instance and run it multiple times to see how things are changing or not changing.



Jason AKA CirqueDeSQLeil
I have given a name to my pain...
MCM SQL Server, MVP


SQL RNNR

Posting Performance Based Questions - Gail Shaw

Lowell
Lowell
One Orange Chip
One Orange Chip (28K reputation)One Orange Chip (28K reputation)One Orange Chip (28K reputation)One Orange Chip (28K reputation)One Orange Chip (28K reputation)One Orange Chip (28K reputation)One Orange Chip (28K reputation)One Orange Chip (28K reputation)

Group: General Forum Members
Points: 28451 Visits: 39963
ok dumb question time guys:
i also have 4 instances on my developer machine, for versions 2005 thru 2012.

when selecting the memory counters in Perfmon, i see instances for 2008, 2008R2 and 2012 , which are Standard(default instance) , Developer(named instance) and Developer(named instance) respectively.

i don't see my 2005(named instance) , which i know is an Express version.

Do Installations of Express Editions not have performance counters available to them?

Lowell

--
help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

SQLRNNR
SQLRNNR
SSC-Dedicated
SSC-Dedicated (32K reputation)SSC-Dedicated (32K reputation)SSC-Dedicated (32K reputation)SSC-Dedicated (32K reputation)SSC-Dedicated (32K reputation)SSC-Dedicated (32K reputation)SSC-Dedicated (32K reputation)SSC-Dedicated (32K reputation)

Group: General Forum Members
Points: 32715 Visits: 18559
Lowell (3/12/2013)
ok dumb question time guys:
i also have 4 instances on my developer machine, for versions 2005 thru 2012.

when selecting the memory counters in Perfmon, i see instances for 2008, 2008R2 and 2012 , which are Standard(default instance) , Developer(named instance) and Developer(named instance) respectively.

i don't see my 2005(named instance) , which i know is an Express version.

Do Installations of Express Editions not have performance counters available to them?


I just checked my express edition counters. I have the counters - but that is SQL 2008 Express. I think there was something changed between 2005 and 2008 though in regards to Perfmon counters - but not sure off the top of my head.



Jason AKA CirqueDeSQLeil
I have given a name to my pain...
MCM SQL Server, MVP


SQL RNNR

Posting Performance Based Questions - Gail Shaw

chewychewy
chewychewy
SSC Veteran
SSC Veteran (240 reputation)SSC Veteran (240 reputation)SSC Veteran (240 reputation)SSC Veteran (240 reputation)SSC Veteran (240 reputation)SSC Veteran (240 reputation)SSC Veteran (240 reputation)SSC Veteran (240 reputation)

Group: General Forum Members
Points: 240 Visits: 520
thanks all
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