According to my notes for SQL Server 2005
Set 'Maximum Server Member (In MB)' to 1 GB less then the amount of RAM on the Server.
Example: 32 GB – 1 GB = 31 GB * 1024 = 31,744 MB, then round it to the nearest thousand
Is this correct? Any other feedback?
In our SQL Server Monitoring Performance tool (Spotlight), below are some alarms, I see some of the following alarms. Any comments? I am trying to get this SQL Server to run more efficiently.
Thanks for any feedback. PLEASE CORRECT MY ABOVE NOTE IF IT IS INCORRECT!
Spotlight Alarm Log:
Normal Network - Percentage Bandwidth (MS TCP Loopback interface)
Disk E: has an average queue length of 41.1. High Disks - Queue Length (E
Network card 'MS TCP Loopback interface' is averaging 100% of its maximum bandwidth.
High Network - Percentage Bandwidth (MS TCP Loopback interface)
Network card 'MS TCP Loopback interface' is averaging 100% of its maximum bandwidth.
High Network - Percentage Bandwidth (MS TCP Loopback interface)
Disk E: has an average queue length of 107.
High Disks - Queue Length (E
The buffer cache page life expectancy is 10 seconds.
High Memory - Page Life Expectancy
Disk E: has an average queue length of 15.1.
High Disks - Queue Length (E
The buffer cache page life expectancy is 10 seconds.
High Memory - Page Life Expectancy
Disk E: has an average queue length of 54.1.
High Disks - Queue Length (E
Set 'Maximum Server Member (In MB)' to 1 GB less then the amount of RAM on the Server.
Example: 32 GB – 1 GB = 31 GB * 1024 = 31,744 MB, then round it to the nearest thousand
Is this correct? Any other feedback?
In our SQL Server Monitoring Performance tool (Spotlight), below are some alarms, I see some of the following alarms. Any comments? I am trying to get this SQL Server to run more efficiently.
Thanks for any feedback. PLEASE CORRECT MY ABOVE NOTE IF IT IS INCORRECT!
Spotlight Alarm Log:
Normal Network - Percentage Bandwidth (MS TCP Loopback interface)
Disk E: has an average queue length of 41.1. High Disks - Queue Length (E
Network card 'MS TCP Loopback interface' is averaging 100% of its maximum bandwidth.
High Network - Percentage Bandwidth (MS TCP Loopback interface)
Network card 'MS TCP Loopback interface' is averaging 100% of its maximum bandwidth.
High Network - Percentage Bandwidth (MS TCP Loopback interface)
Disk E: has an average queue length of 107.
High Disks - Queue Length (E
The buffer cache page life expectancy is 10 seconds.
High Memory - Page Life Expectancy
Disk E: has an average queue length of 15.1.
High Disks - Queue Length (E
The buffer cache page life expectancy is 10 seconds.
High Memory - Page Life Expectancy
Disk E: has an average queue length of 54.1.
High Disks - Queue Length (E
