September 16, 2010 at 3:00 pm
My company has a shared SQL server environment. Because of the limitations of our application, each customers data has to exist in it's own instance of SQL server.
We currently have a DB server that has 15 instances of SQL server EXPRESS 2008 R2 installed. The machine runs really well and performance is for the most part fast.
The machine has 8GB of ram and 15 instances of SQL EXPRESS. If I didn't set the maximum memory value, each instance would attempt to use the maximum for express, which is 1GB of RAM.
Most of the databases are small, between 200MB and 5GB. The usage patterns are almost identical for the small 200 MB DB's and the larger 5GB DB's.
My question is how do I know if I'm starving a particular instance of SQL server for memory. Here is the typical consideration I'm using. Probably incorrect, but that's why I'm asking here. :w00t:
If the DB is "X" MB in size I set the SQL Maximum memory to "X" here is my basic logic.
DB SIZE: SQL MEMORY:
65MB 128MB
500MB 256MB
2GB 512MB
5GB 768MB
My question is, what performance counters inside of SQL can I look at to see if my instances of SQL don't have sufficient memory? Most articles on the web assume you have one instance of SQL on the box and tell you to look at global values for the server. What I'm looking for is some exact performance counters/SQL Reports, that I can view that show me if my allocation model is providing adequate RAM for the SQL Instances, or if the DB performance could be improved by allocating more RAM. Please keep in mind this is SQL Express and each instance has a hard limit of 1GB. I'm simply trying to make the most out of 8GB of RAM by throttling SQL instances to the maximum ideal memory that a particular instance should need.
Thank you in advance.
September 17, 2010 at 4:57 am
Try windows performance monitor..u can add counter for each instance..
September 17, 2010 at 5:46 am
TO find memory usage
select object_name,counter_name, cntr_value 'Memory Used Size (KB)'
FROM
Sys.dm_os_performance_counters
where object_name like '%SQLServer:Memory Manager%'
also you can add the same performance counters in PERFMON
also, i have a smal suggestion...instead of 15 instances on 1 machine, can u have 15 databases on 1 instance and isolate them based on security?
September 17, 2010 at 10:02 am
This is simple....run your perf mon look for Page life expectancy(sql server memory), for each SQL instance. make sure the PLE is no less then 300, preferably higher like 1000 is better.
if it is lower then 300 then I would adjust the memory....I would run a trace for 24 hours at 5 min intervals to a delimited file, then take a look.
Good luck
September 17, 2010 at 3:14 pm
Mandar Alawani (9/17/2010)
also, i have a smal suggestion...instead of 15 instances on 1 machine, can u have 15 databases on 1 instance and isolate them based on security?
I have an unrelated question - with 15 isolated databases on 1 instance, how do you show only the databases that are pertaining to a certain user instead of all of the dbs on the server in Management Studio?
September 17, 2010 at 3:35 pm
In 08 you can run the activity monitor, under process you can filter the DB then look at the resources.
There is wide range of items to look at there.
September 17, 2010 at 3:45 pm
I didn't mean to monitor the activities - just plain view the list of databases that belong to a certain user only. Say, there are 100 databases on the server, but only 15 are for me. So I don't want to see all the other 85 unrelated dbs when I connect to the server from the management studio. I know I can filter out the tables, procs, but I don't see a way to filter database names.
September 17, 2010 at 3:51 pm
I know exactly what you mean now....I was able to get the MS to do in I think 2000 but havent been able to do it since...
Start a new thread would be the best bet
September 17, 2010 at 7:14 pm
The reason for multiple instances is because the application is only capable of calling multiple DB paths, not multiple database names. If we had to deal with multiple DB names the long SQL updates we do would get tricky to deal with.
September 17, 2010 at 7:24 pm
Mandar Alawani (9/17/2010)
TO find memory usageselect object_name,counter_name, cntr_value 'Memory Used Size (KB)'
FROM
Sys.dm_os_performance_counters
where object_name like '%SQLServer:Memory Manager%'
also you can add the same performance counters in PERFMON
also, i have a smal suggestion...instead of 15 instances on 1 machine, can u have 15 databases on 1 instance and isolate them based on security?
Here is a small mod to your script..
select object_name,counter_name, cntr_value / 1024 'Memory Used Size (MB)'
FROM
Sys.dm_os_performance_counters
WHERE object_name LIKE '%Memory Manager%'
Which gives me
counter_nameMemory Used Size (MB)
Connection Memory (KB) 0
Granted Workspace Memory (KB) 0
Lock Memory (KB) 0
Lock Blocks Allocated 3
Lock Owner Blocks Allocated 0
Lock Blocks 0
Lock Owner Blocks 0
Maximum Workspace Memory (KB) 62
Memory Grants Outstanding 0
Memory Grants Pending 0
Optimizer Memory (KB) 0
SQL Cache Memory (KB) 1
Target Server Memory (KB) 128
Total Server Memory (KB) 116
Ok so now how does this show me that this instance of SQL could use more memory? Thanks for everyones help so far 😀
September 18, 2010 at 7:00 am
hard to tell with just this since its a snapshot many things can happen between snapshots, example what if the OS ran out of memory a min before you ran the script and therefore SQL dumped memory....but if you ran this before the dump total could have been bigger then target indicated memory pressure...any how lots of reasons
the best way to do it is run perfmon and look for target,total memory and PLE(page life expactancy)....do this at one time on all the instances
on the supplied results
please look at total vs target... target is the amount sql wants and total is how much is being used...in this case since total is not equal to target chances are this one is not the issue.....
September 18, 2010 at 8:10 am
456789psw (9/18/2010)
hard to tell with just this since its a snapshot many things can happen between snapshots, example what if the OS ran out of memory a min before you ran the script and therefore SQL dumped memory....but if you ran this before the dump total could have been bigger then target indicated memory pressure...any how lots of reasonsthe best way to do it is run perfmon and look for target,total memory and PLE(page life expactancy)....do this at one time on all the instances
on the supplied results
please look at total vs target... target is the amount sql wants and total is how much is being used...in this case since total is not equal to target chances are this one is not the issue.....
Thank you for the reply. I have a performance monitor running. I wanted to make sure I tried everyones input. I'm planning on reporting back on Monday with my findings.
Agin thank you very much for everyones replies and assistance.
September 20, 2010 at 3:24 pm
456789psw (9/17/2010)
This is simple....run your perf mon look for Page life expectancy(sql server memory), for each SQL instance. make sure the PLE is no less then 300, preferably higher like 1000 is better.if it is lower then 300 then I would adjust the memory....I would run a trace for 24 hours at 5 min intervals to a delimited file, then take a look.
Good luck
Hello.. I ran the performance monitor you suggested. It seems to dip below the 1000 occasionally and then get really high? Does this look adequate?
"(PDH-CSV 4.0) (US Mountain Standard Time)(420)","\\DB09\MSSQL$0219:Buffer Manager\Page life expectancy"
"09/18/2010 12:52:49.413","11446"
"09/18/2010 12:57:49.413","11446"
"09/18/2010 13:02:49.413","11446"
"09/18/2010 13:07:49.413","11446"
"09/18/2010 13:12:49.413","11478"
"09/18/2010 13:17:49.413","11778"
"09/18/2010 13:22:49.413","12078"
"09/18/2010 13:27:49.413","12378"
"09/18/2010 13:32:49.413","12678"
"09/18/2010 13:37:49.413","12978"
"09/18/2010 13:42:49.413","13278"
"09/18/2010 13:47:49.413","13578"
"09/18/2010 13:52:49.413","13878"
"09/18/2010 13:57:49.413","14178"
"09/18/2010 14:02:49.413","14478"
"09/18/2010 14:07:49.413","14778"
"09/18/2010 14:12:49.413","15078"
"09/18/2010 14:17:49.413","15378"
"09/18/2010 14:22:49.413","15679"
"09/18/2010 14:27:49.413","15978"
"09/18/2010 14:32:49.413","16278"
"09/18/2010 14:37:49.413","16579"
"09/18/2010 14:42:49.413","16878"
"09/18/2010 14:47:49.413","17178"
"09/18/2010 14:52:49.413","17479"
"09/18/2010 14:57:49.413","17778"
"09/18/2010 15:02:49.413","18078"
"09/18/2010 15:07:49.413","18378"
"09/18/2010 15:12:49.413","18678"
"09/18/2010 15:17:49.413","18978"
"09/18/2010 15:22:49.413","19278"
"09/18/2010 15:27:49.413","19578"
"09/18/2010 15:32:49.413","19878"
"09/18/2010 15:37:49.413","20178"
"09/18/2010 15:42:49.413","20478"
"09/18/2010 15:47:49.413","20778"
"09/18/2010 15:52:49.413","21078"
"09/18/2010 15:57:49.413","21379"
"09/18/2010 16:02:49.413","21678"
"09/18/2010 16:07:49.413","21978"
"09/18/2010 16:12:49.413","22278"
"09/18/2010 16:17:49.413","22578"
"09/18/2010 16:22:49.413","22878"
"09/18/2010 16:27:49.413","23178"
"09/18/2010 16:32:49.413","23479"
"09/18/2010 16:37:49.413","23778"
"09/18/2010 16:42:49.413","24078"
"09/18/2010 16:47:49.413","24379"
"09/18/2010 16:52:49.413","24678"
"09/18/2010 16:57:49.413","24978"
"09/18/2010 17:02:49.508","25278"
"09/18/2010 17:07:49.626","25578"
"09/18/2010 17:12:49.499","25878"
"09/18/2010 17:17:49.447","26178"
"09/18/2010 17:22:49.426","26478"
"09/18/2010 17:27:49.430","26778"
"09/18/2010 17:32:49.416","27078"
"09/18/2010 17:37:49.416","27377"
"09/18/2010 17:42:49.416","27678"
"09/18/2010 17:47:49.416","27978"
"09/18/2010 17:52:49.416","28277"
"09/18/2010 17:57:49.416","28578"
"09/18/2010 18:02:49.416","28877"
"09/18/2010 18:07:49.416","29178"
"09/18/2010 18:12:49.416","29478"
"09/18/2010 18:17:49.416","29777"
"09/18/2010 18:22:49.416","30078"
"09/18/2010 18:27:49.416","30378"
"09/18/2010 18:32:49.416","30677"
"09/18/2010 18:37:49.416","30978"
"09/18/2010 18:42:49.416","31278"
"09/18/2010 18:47:49.416","31577"
"09/18/2010 18:52:49.416","31878"
"09/18/2010 18:57:49.416","32177"
"09/18/2010 19:02:49.416","32478"
"09/18/2010 19:07:49.416","32778"
"09/18/2010 19:12:49.416","33077"
"09/18/2010 19:17:49.416","33378"
"09/18/2010 19:22:49.416","33678"
"09/18/2010 19:27:49.416","33977"
"09/18/2010 19:32:49.416","34278"
"09/18/2010 19:37:49.416","34578"
"09/18/2010 19:42:49.416","34877"
"09/18/2010 19:47:49.416","35178"
"09/18/2010 19:52:49.416","35477"
"09/18/2010 19:57:49.416","35778"
"09/18/2010 20:02:49.416","36078"
"09/18/2010 20:07:49.416","36377"
"09/18/2010 20:12:49.416","36678"
"09/18/2010 20:17:49.416","36978"
"09/18/2010 20:22:49.416","37277"
"09/18/2010 20:27:49.416","37578"
"09/18/2010 20:32:49.416","37878"
"09/18/2010 20:37:49.416","38178"
"09/18/2010 20:42:49.416","38477"
"09/18/2010 20:47:49.416","38778"
"09/18/2010 20:52:49.416","39078"
"09/18/2010 20:57:49.416","39377"
"09/18/2010 21:02:49.416","39678"
"09/18/2010 21:07:49.416","39977"
"09/18/2010 21:12:49.416","40278"
"09/18/2010 21:17:49.416","40578"
"09/18/2010 21:22:49.416","40877"
"09/18/2010 21:27:49.416","41178"
"09/18/2010 21:32:49.416","41478"
"09/18/2010 21:37:49.416","41778"
"09/18/2010 21:42:49.416","42078"
"09/18/2010 21:47:49.416","42377"
"09/18/2010 21:52:49.416","42678"
"09/18/2010 21:57:49.416","42978"
"09/18/2010 22:02:49.416","43278"
"09/18/2010 22:07:49.416","43578"
"09/18/2010 22:12:49.416","43877"
"09/18/2010 22:17:49.416","44178"
"09/18/2010 22:22:49.416","44477"
"09/18/2010 22:27:49.416","44778"
"09/18/2010 22:32:49.416","45078"
"09/18/2010 22:37:49.416","45378"
"09/18/2010 22:42:49.416","45678"
"09/18/2010 22:47:49.416","45978"
"09/18/2010 22:52:49.416","46277"
"09/18/2010 22:57:49.416","46578"
"09/18/2010 23:02:49.416","46878"
"09/18/2010 23:07:49.416","47177"
"09/18/2010 23:12:49.416","47478"
"09/18/2010 23:17:49.416","47777"
"09/18/2010 23:22:49.416","48078"
"09/18/2010 23:27:49.416","48378"
"09/18/2010 23:32:49.416","48677"
"09/18/2010 23:37:49.416","48978"
"09/18/2010 23:42:49.416","49278"
"09/18/2010 23:47:49.416","49578"
"09/18/2010 23:52:49.416","49878"
"09/18/2010 23:57:49.416","50178"
"09/19/2010 00:02:49.416","50478"
"09/19/2010 00:07:49.416","50778"
"09/19/2010 00:12:49.416","51077"
"09/19/2010 00:17:49.416","51378"
"09/19/2010 00:22:49.416","51677"
"09/19/2010 00:27:49.416","51978"
"09/19/2010 00:32:49.416","52278"
"09/19/2010 00:37:49.416","52577"
"09/19/2010 00:42:49.416","52878"
"09/19/2010 00:47:49.416","53178"
"09/19/2010 00:52:49.416","53477"
"09/19/2010 00:57:49.416","53778"
"09/19/2010 01:02:49.416","54077"
"09/19/2010 01:07:49.416","54378"
"09/19/2010 01:12:49.416","54678"
"09/19/2010 01:17:49.416","54978"
"09/19/2010 01:22:49.416","55278"
"09/19/2010 01:27:49.416","55578"
"09/19/2010 01:32:49.416","55877"
"09/19/2010 01:37:49.416","56178"
"09/19/2010 01:42:49.416","56477"
"09/19/2010 01:47:49.416","56778"
"09/19/2010 01:52:49.416","57078"
"09/19/2010 01:57:49.416","57378"
"09/19/2010 02:02:49.416","57678"
"09/19/2010 02:07:49.449","57977"
"09/19/2010 02:12:49.667","58278"
"09/19/2010 02:17:49.507","58577"
"09/19/2010 02:22:49.447","58878"
"09/19/2010 02:27:49.427","59177"
"09/19/2010 02:32:49.432","59477"
"09/19/2010 02:37:49.418","59778"
"09/19/2010 02:42:49.418","60077"
"09/19/2010 02:47:49.418","60377"
"09/19/2010 02:52:49.418","60678"
"09/19/2010 02:57:49.418","60977"
"09/19/2010 03:02:49.418","61278"
"09/19/2010 03:07:49.418","61577"
"09/19/2010 03:12:49.418","61877"
"09/19/2010 03:17:49.418","62177"
"09/19/2010 03:22:49.418","62477"
"09/19/2010 03:27:49.418","62778"
"09/19/2010 03:32:49.418","63077"
"09/19/2010 03:37:49.418","63378"
"09/19/2010 03:42:49.418","63677"
"09/19/2010 03:47:49.418","63977"
"09/19/2010 03:52:49.418","64277"
"09/19/2010 03:57:49.418","64577"
"09/19/2010 04:02:49.418","64878"
"09/19/2010 04:07:49.418","65177"
"09/19/2010 04:12:49.418","65477"
"09/19/2010 04:17:49.418","65778"
"09/19/2010 04:22:49.418","66077"
"09/19/2010 04:27:49.418","66377"
"09/19/2010 04:32:49.418","66677"
"09/19/2010 04:37:49.418","66977"
"09/19/2010 04:42:49.418","67278"
"09/19/2010 04:47:49.418","67577"
"09/19/2010 04:52:49.418","67878"
"09/19/2010 04:57:49.418","68177"
"09/19/2010 05:02:49.418","68477"
"09/19/2010 05:07:49.418","68778"
"09/19/2010 05:12:49.418","69077"
"09/19/2010 05:17:49.418","69377"
"09/19/2010 05:22:49.418","69678"
"09/19/2010 05:27:49.418","69977"
"09/19/2010 05:32:49.418","70278"
"09/19/2010 05:37:49.418","70577"
"09/19/2010 05:42:49.418","70878"
"09/19/2010 05:47:49.418","71177"
"09/19/2010 05:52:49.418","71477"
"09/19/2010 05:57:49.418","71778"
"09/19/2010 06:02:49.418","72077"
"09/19/2010 06:07:49.418","72377"
"09/19/2010 06:12:49.418","72678"
"09/19/2010 06:17:49.418","72977"
"09/19/2010 06:22:49.418","73278"
"09/19/2010 06:27:49.418","73577"
"09/19/2010 06:32:49.418","73877"
"09/19/2010 06:37:49.418","74177"
"09/19/2010 06:42:49.418","74477"
"09/19/2010 06:47:49.418","74778"
"09/19/2010 06:52:49.418","75077"
"09/19/2010 06:57:49.418","75377"
"09/19/2010 07:02:49.418","75677"
"09/19/2010 07:07:49.418","75977"
"09/19/2010 07:12:49.418","76278"
"09/19/2010 07:17:49.418","76577"
"09/19/2010 07:22:49.418","76877"
"09/19/2010 07:27:49.418","77178"
"09/19/2010 07:32:49.418","77477"
"09/19/2010 07:37:49.418","77778"
"09/19/2010 07:42:49.418","78078"
"09/19/2010 07:47:49.418","78377"
"09/19/2010 07:52:49.418","78678"
"09/19/2010 07:57:49.418","78977"
"09/19/2010 08:02:49.418","79277"
"09/19/2010 08:07:49.418","79577"
"09/19/2010 08:12:49.418","79877"
"09/19/2010 08:17:49.418","80178"
"09/19/2010 08:22:49.418","80477"
"09/19/2010 08:27:49.418","80777"
"09/19/2010 08:32:49.418","81077"
"09/19/2010 08:37:49.418","81377"
"09/19/2010 08:42:49.418","81678"
"09/19/2010 08:47:49.418","81977"
"09/19/2010 08:52:49.418","82278"
"09/19/2010 08:57:49.418","82577"
"09/19/2010 09:02:49.418","82877"
"09/19/2010 09:07:49.418","83178"
"09/19/2010 09:12:49.418","83477"
"09/19/2010 09:17:49.418","83777"
"09/19/2010 09:22:49.418","84077"
"09/19/2010 09:27:49.418","84377"
"09/19/2010 09:32:49.418","84677"
"09/19/2010 09:37:49.418","84977"
"09/19/2010 09:42:49.418","85277"
"09/19/2010 09:47:49.418","85577"
"09/19/2010 09:52:49.418","85878"
"09/19/2010 09:57:49.418","86177"
"09/19/2010 10:02:49.418","86477"
"09/19/2010 10:07:49.418","86777"
"09/19/2010 10:12:49.418","87077"
"09/19/2010 10:17:49.418","87378"
"09/19/2010 10:22:49.418","87677"
"09/19/2010 10:27:49.418","87977"
"09/19/2010 10:32:49.418","88278"
"09/19/2010 10:37:49.418","88577"
"09/19/2010 10:42:49.418","88877"
"09/19/2010 10:47:49.418","89177"
"09/19/2010 10:52:49.418","89477"
"09/19/2010 10:57:49.418","89778"
"09/19/2010 11:02:49.418","90077"
"09/19/2010 11:07:49.418","90377"
"09/19/2010 11:12:49.418","90677"
"09/19/2010 11:17:49.671","90977"
"09/19/2010 11:22:49.540","91277"
"09/19/2010 11:27:49.458","91577"
"09/19/2010 11:32:49.442","91877"
"09/19/2010 11:37:49.433","92177"
"09/19/2010 11:42:49.420","92477"
"09/19/2010 11:47:49.420","92776"
"09/19/2010 11:52:49.420","93077"
"09/19/2010 11:57:49.420","93377"
"09/19/2010 12:02:49.420","93677"
"09/19/2010 12:07:49.420","93977"
"09/19/2010 12:12:49.420","94276"
"09/19/2010 12:17:49.420","94577"
"09/19/2010 12:22:49.420","94877"
"09/19/2010 12:27:49.420","95177"
"09/19/2010 12:32:49.420","95477"
"09/19/2010 12:37:49.420","95777"
"09/19/2010 12:42:49.420","96077"
"09/19/2010 12:47:49.420","96377"
"09/19/2010 12:52:49.420","96677"
"09/19/2010 12:57:49.420","96977"
"09/19/2010 13:02:49.420","97277"
"09/19/2010 13:07:49.420","97577"
"09/19/2010 13:12:49.420","97877"
"09/19/2010 13:17:49.420","98177"
"09/19/2010 13:22:49.420","98477"
"09/19/2010 13:27:49.420","98777"
"09/19/2010 13:32:49.420","99077"
"09/19/2010 13:37:49.420","99377"
"09/19/2010 13:42:49.420","99677"
"09/19/2010 13:47:49.420","99977"
"09/19/2010 13:52:49.420","100276"
"09/19/2010 13:57:49.420","100577"
"09/19/2010 14:02:49.420","100877"
"09/19/2010 14:07:49.420","101177"
"09/19/2010 14:12:49.420","101477"
"09/19/2010 14:17:49.420","101777"
"09/19/2010 14:22:49.420","102077"
"09/19/2010 14:27:49.420","102377"
"09/19/2010 14:32:49.420","102677"
"09/19/2010 14:37:49.420","102977"
"09/19/2010 14:42:49.420","103277"
"09/19/2010 14:47:49.420","103576"
"09/19/2010 14:52:49.420","103877"
"09/19/2010 14:57:49.420","104177"
"09/19/2010 15:02:49.420","104477"
"09/19/2010 15:07:49.420","104777"
"09/19/2010 15:12:49.420","105077"
"09/19/2010 15:17:49.420","105377"
"09/19/2010 15:22:49.420","105677"
"09/19/2010 15:27:49.420","105976"
"09/19/2010 15:32:49.420","106277"
"09/19/2010 15:37:49.420","106577"
"09/19/2010 15:42:49.420","106877"
"09/19/2010 15:47:49.420","107177"
"09/19/2010 15:52:49.420","107477"
"09/19/2010 15:57:49.420","107777"
"09/19/2010 16:02:49.420","108077"
"09/19/2010 16:07:49.420","108377"
"09/19/2010 16:12:49.420","108677"
"09/19/2010 16:17:49.420","108976"
"09/19/2010 16:22:49.420","109277"
"09/19/2010 16:27:49.420","109577"
"09/19/2010 16:32:49.420","109877"
"09/19/2010 16:37:49.420","110177"
"09/19/2010 16:42:49.420","110477"
"09/19/2010 16:47:49.420","110777"
"09/19/2010 16:52:49.420","111077"
"09/19/2010 16:57:49.420","111377"
"09/19/2010 17:02:49.420","111677"
"09/19/2010 17:07:49.420","111976"
"09/19/2010 17:12:49.420","112277"
"09/19/2010 17:17:49.420","112577"
"09/19/2010 17:22:49.420","112877"
"09/19/2010 17:27:49.420","113177"
"09/19/2010 17:32:49.420","113476"
"09/19/2010 17:37:49.420","113777"
"09/19/2010 17:42:49.420","114077"
"09/19/2010 17:47:49.420","114376"
"09/19/2010 17:52:49.420","114677"
"09/19/2010 17:57:49.420","114976"
"09/19/2010 18:02:49.420","115277"
"09/19/2010 18:07:49.420","115577"
"09/19/2010 18:12:49.420","115876"
"09/19/2010 18:17:49.420","116177"
"09/19/2010 18:22:49.420","116477"
"09/19/2010 18:27:49.420","116777"
"09/19/2010 18:32:49.420","117077"
"09/19/2010 18:37:49.420","117377"
"09/19/2010 18:42:49.420","117677"
"09/19/2010 18:47:49.420","117977"
"09/19/2010 18:52:49.420","118276"
"09/19/2010 18:57:49.420","118577"
"09/19/2010 19:02:49.420","118877"
"09/19/2010 19:07:49.420","119177"
"09/19/2010 19:12:49.420","119477"
"09/19/2010 19:17:49.420","119776"
"09/19/2010 19:22:49.420","120077"
"09/19/2010 19:27:49.420","120377"
"09/19/2010 19:32:49.420","120677"
"09/19/2010 19:37:49.420","120977"
"09/19/2010 19:42:49.420","121277"
"09/19/2010 19:47:49.420","121577"
"09/19/2010 19:52:49.420","121877"
"09/19/2010 19:57:49.420","122177"
"09/19/2010 20:02:49.420","122477"
"09/19/2010 20:07:49.420","122776"
"09/19/2010 20:12:49.420","123077"
"09/19/2010 20:17:49.420","123377"
"09/19/2010 20:22:49.602","123677"
"09/19/2010 20:27:49.569","123977"
"09/19/2010 20:32:49.484","124276"
"09/19/2010 20:37:49.442","124577"
"09/19/2010 20:42:49.433","124876"
"09/19/2010 20:47:49.420","125177"
"09/19/2010 20:52:49.421","125476"
"09/19/2010 20:57:49.421","125777"
"09/19/2010 21:02:49.421","126076"
"09/19/2010 21:07:49.421","126376"
"09/19/2010 21:12:49.421","126677"
"09/19/2010 21:17:49.421","126976"
"09/19/2010 21:22:49.421","127276"
"09/19/2010 21:27:49.421","127577"
"09/19/2010 21:32:49.421","127876"
"09/19/2010 21:37:49.421","128177"
"09/19/2010 21:42:49.421","128477"
"09/19/2010 21:47:49.421","128776"
"09/19/2010 21:52:49.421","129077"
"09/19/2010 21:57:49.421","129376"
"09/19/2010 22:02:49.421","129676"
"09/19/2010 22:07:49.421","129977"
"09/19/2010 22:12:49.421","130276"
"09/19/2010 22:17:49.421","130577"
"09/19/2010 22:22:49.421","130877"
"09/19/2010 22:27:49.421","131176"
"09/19/2010 22:32:49.421","131477"
"09/19/2010 22:37:49.421","131776"
"09/19/2010 22:42:49.421","132077"
"09/19/2010 22:47:49.421","132377"
"09/19/2010 22:52:49.421","132676"
"09/19/2010 22:57:49.421","132977"
"09/19/2010 23:02:49.421","133276"
"09/19/2010 23:07:49.421","133576"
"09/19/2010 23:12:49.421","133877"
"09/19/2010 23:17:49.421","134176"
"09/19/2010 23:22:49.421","134476"
"09/19/2010 23:27:49.421","134777"
"09/19/2010 23:32:49.421","135076"
"09/19/2010 23:37:49.421","135376"
"09/19/2010 23:42:49.421","135677"
"09/19/2010 23:47:49.421","135976"
"09/19/2010 23:52:49.421","136277"
"09/19/2010 23:57:49.421","136577"
"09/20/2010 00:02:49.421","136877"
"09/20/2010 00:07:49.421","137176"
"09/20/2010 00:12:49.421","137477"
"09/20/2010 00:17:49.421","137777"
"09/20/2010 00:22:49.421","138076"
"09/20/2010 00:27:49.421","138377"
"09/20/2010 00:32:49.421","138676"
"09/20/2010 00:37:49.421","138976"
"09/20/2010 00:42:49.421","139277"
"09/20/2010 00:47:49.421","139576"
"09/20/2010 00:52:49.421","139877"
"09/20/2010 00:57:49.421","140176"
"09/20/2010 01:02:49.421","140476"
"09/20/2010 01:07:49.421","140777"
"09/20/2010 01:12:49.421","141076"
"09/20/2010 01:17:49.421","141376"
"09/20/2010 01:22:49.421","141677"
"09/20/2010 01:27:49.421","141976"
"09/20/2010 01:32:49.421","142276"
"09/20/2010 01:37:49.421","142577"
"09/20/2010 01:42:49.421","142876"
"09/20/2010 01:47:49.421","143177"
"09/20/2010 01:52:49.421","143476"
"09/20/2010 01:57:49.421","143777"
"09/20/2010 02:02:49.421","144076"
"09/20/2010 02:07:49.421","144376"
"09/20/2010 02:12:49.421","144677"
"09/20/2010 02:17:49.421","144976"
"09/20/2010 02:22:49.421","145277"
"09/20/2010 02:27:49.421","145576"
"09/20/2010 02:32:49.421","145876"
"09/20/2010 02:37:49.421","146177"
"09/20/2010 02:42:49.421","146476"
"09/20/2010 02:47:49.421","146777"
"09/20/2010 02:52:49.421","147076"
"09/20/2010 02:57:49.421","147377"
"09/20/2010 03:02:49.421","147676"
"09/20/2010 03:07:49.421","147976"
"09/20/2010 03:12:49.421","148277"
"09/20/2010 03:17:49.421","148576"
"09/20/2010 03:22:49.421","148877"
"09/20/2010 03:27:49.421","149176"
"09/20/2010 03:32:49.421","149476"
"09/20/2010 03:37:49.421","149777"
"09/20/2010 03:42:49.421","150076"
"09/20/2010 03:47:49.421","150377"
"09/20/2010 03:52:49.421","150676"
"09/20/2010 03:57:49.421","150976"
"09/20/2010 04:02:49.421","59"
"09/20/2010 04:07:49.421","359"
"09/20/2010 04:12:49.421","660"
"09/20/2010 04:17:49.421","959"
"09/20/2010 04:22:49.421","1259"
"09/20/2010 04:27:49.421","1560"
"09/20/2010 04:32:49.421","1859"
"09/20/2010 04:37:49.421","2160"
"09/20/2010 04:42:49.421","2459"
"09/20/2010 04:47:49.421","2760"
"09/20/2010 04:52:49.421","3059"
"09/20/2010 04:57:49.421","3359"
"09/20/2010 05:02:49.421","3659"
"09/20/2010 05:07:49.421","3959"
"09/20/2010 05:12:49.421","4259"
"09/20/2010 05:17:49.421","4559"
"09/20/2010 05:22:49.421","4756"
"09/20/2010 05:27:49.542","4756"
"09/20/2010 05:32:49.612","4756"
"09/20/2010 05:37:49.494","4756"
"09/20/2010 05:42:49.441","4756"
"09/20/2010 05:47:49.435","4756"
"09/20/2010 05:52:49.422","4756"
"09/20/2010 05:57:49.423","4756"
"09/20/2010 06:02:49.423","4756"
"09/20/2010 06:07:49.423","2662"
"09/20/2010 06:12:49.423","2662"
"09/20/2010 06:17:49.423","2662"
"09/20/2010 06:22:49.423","2662"
"09/20/2010 06:27:49.423","2662"
"09/20/2010 06:32:49.423","2662"
"09/20/2010 06:37:49.423","2662"
"09/20/2010 06:42:49.423","2662"
"09/20/2010 06:47:49.423","2662"
"09/20/2010 06:52:49.423","2840"
"09/20/2010 06:57:49.423","3140"
"09/20/2010 07:02:49.423","3441"
"09/20/2010 07:07:49.423","3740"
"09/20/2010 07:12:49.423","4041"
"09/20/2010 07:17:49.423","4341"
"09/20/2010 07:22:49.423","190"
"09/20/2010 07:27:49.423","490"
"09/20/2010 07:32:49.423","790"
"09/20/2010 07:37:49.423","1090"
"09/20/2010 07:42:49.423","1390"
"09/20/2010 07:47:49.423","1690"
"09/20/2010 07:52:49.423","1723"
"09/20/2010 07:57:49.423","1723"
"09/20/2010 08:02:49.423","1723"
"09/20/2010 08:07:49.423","1723"
"09/20/2010 08:12:49.423","1723"
"09/20/2010 08:17:49.423","1766"
"09/20/2010 08:22:49.423","2066"
"09/20/2010 08:27:49.423","2366"
"09/20/2010 08:32:49.423","2666"
"09/20/2010 08:37:49.423","2966"
"09/20/2010 08:42:49.423","3266"
"09/20/2010 08:47:49.423","3566"
"09/20/2010 08:52:49.423","3866"
"09/20/2010 08:57:49.423","4166"
"09/20/2010 09:02:49.423","4466"
"09/20/2010 09:07:49.423","4766"
"09/20/2010 09:12:49.423","4940"
"09/20/2010 09:17:49.423","4940"
"09/20/2010 09:22:49.423","4940"
"09/20/2010 09:27:49.423","4940"
"09/20/2010 09:32:49.423","4940"
"09/20/2010 09:37:49.423","4940"
"09/20/2010 09:42:49.423","4940"
"09/20/2010 09:47:49.423","4940"
"09/20/2010 09:52:49.423","4940"
"09/20/2010 09:57:49.423","4940"
"09/20/2010 10:02:49.423","4940"
"09/20/2010 10:07:49.423","4940"
"09/20/2010 10:12:49.423","4940"
"09/20/2010 10:17:49.423","4940"
"09/20/2010 10:22:49.423","4940"
"09/20/2010 10:27:49.423","4940"
"09/20/2010 10:32:49.423","4940"
"09/20/2010 10:37:49.423","5225"
"09/20/2010 10:42:49.423","5526"
September 20, 2010 at 4:01 pm
This pretty much tells you that this instance is ok,
you should run profiler and capture all the other instances at the same time....that way you can run one trace....save you some time.....and you will be able to quickly compare.
September 20, 2010 at 5:09 pm
456789psw (9/20/2010)
This pretty much tells you that this instance is ok,you should run profiler and capture all the other instances at the same time....that way you can run one trace....save you some time.....and you will be able to quickly compare.
So there were a few places were it dipped below. Does this mean that if I see it below 1000 for maybe 4 hours and then it goes back up that I have enough memory during non-peak times? Or would I see this value extremely low for then entire 24 hour period, and that would tell me I didn't have enough memory?
Viewing 15 posts - 1 through 15 (of 15 total)
You must be logged in to reply to this topic. Login to reply