How can you tell if a SQL Server instance max'ed out bottleneck is Memory?
-
hi - How can you tell if a SQL Server instance max'ed out bottleneck is Memory? It's on a 8GB box with two processors. Seems CPU ok. Memory max out the whole time while this big SELECT-INTO statement is running. Avg Disk Queue lenght ok - avg below 1.0 so doesn't appear disk/paging is causing problem. However, fact from Task Manager memory keeps 7 GB out of 8GB over the whole time doesn't mean memory is the bottleneck? Or is it? The same query runs on another SQL server with double the RAM finishes a few times quicker however. Any advises? Thanks
dev
-
hi - How can you tell if a SQL Server instance max'ed out bottleneck is Memory? It's on a 8GB box with two processors. Seems CPU ok. Memory max out the whole time while this big SELECT-INTO statement is running. Avg Disk Queue lenght ok - avg below 1.0 so doesn't appear disk/paging is causing problem. However, fact from Task Manager memory keeps 7 GB out of 8GB over the whole time doesn't mean memory is the bottleneck? Or is it? The same query runs on another SQL server with double the RAM finishes a few times quicker however. Any advises? Thanks
dev
Check the configuration on the SQL Server instances to see what the maximum amount of memory is that is allocated to them. I'm don't remember where it is, but that is a starting point.
-
Check the configuration on the SQL Server instances to see what the maximum amount of memory is that is allocated to them. I'm don't remember where it is, but that is a starting point.
Thanks alot It works :)