TANGLAD
asked on
SQL Server 2005 disk/memory performance.
SQL Server 2005 disk/memory performance.
OS: Windows 2003 Server (32)
Memory installed: 3,6 GB
Pagefile location: C:
Pagefile minimum: 2 GB
Pagefile maximum: 4 GB
SQL Databasefiles on seperate partition and seperate physical array than drive C:
SQL logs on seperate partition but same physical array as Database files
Memory status: 1.4 GB free physical memory
Pagefile usage: 2 GB
SQL Server memory:
AWE: no
Minimum mem = 0
Maximum mem = 2147483647
Index memory = 0
Minimum memory pr. query: 2048
The Issue:
Some queries makes disk activity peak. Using perfmon I can see that the heavy disk activity is on drive C: for 10 seconds. I think i could be the pagefile og tempdb that is working heavily.
How do I monitor the pagefile activity to be sure that it's the bottleneck?
How to set up the SQL server 2005 memory handling properly to avoid pagefile activity hven doing heavy queries. It's a SQL Server 2005 standard edition.
OS: Windows 2003 Server (32)
Memory installed: 3,6 GB
Pagefile location: C:
Pagefile minimum: 2 GB
Pagefile maximum: 4 GB
SQL Databasefiles on seperate partition and seperate physical array than drive C:
SQL logs on seperate partition but same physical array as Database files
Memory status: 1.4 GB free physical memory
Pagefile usage: 2 GB
SQL Server memory:
AWE: no
Minimum mem = 0
Maximum mem = 2147483647
Index memory = 0
Minimum memory pr. query: 2048
The Issue:
Some queries makes disk activity peak. Using perfmon I can see that the heavy disk activity is on drive C: for 10 seconds. I think i could be the pagefile og tempdb that is working heavily.
How do I monitor the pagefile activity to be sure that it's the bottleneck?
How to set up the SQL server 2005 memory handling properly to avoid pagefile activity hven doing heavy queries. It's a SQL Server 2005 standard edition.
ASKER
Moved tempdb and YES that is the one causing heavy disk-activity.
How can I avoid that. Is tempdb and installed memory related? I mean will more memory avoid disk access to tempdb.
How can I avoid that. Is tempdb and installed memory related? I mean will more memory avoid disk access to tempdb.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
one "quick" way to "prove" this is to move tempdb onto a different sector to see if that sector gets more hits!!
/Richard