Announcement

Collapse
No announcement yet.

SQL 2005 Enterprise cluster memory amount vs page file

Collapse
X
  • Filter
  • Time
  • Show
Clear All
new posts

  • SQL 2005 Enterprise cluster memory amount vs page file

    We are currently planning a SQL cluster using 2005 Enterprise ver. in a 2003 multi-master domain with AD and Group Policy enabled

    While we are only in the planning stages at this point, a question was asked about memory capacity and page file activity. More specifically, at what point is disc activity in SQL actually occurr, and what counters would you enable to monitor this activity.
    We just want to find out at what point the swap file would be engaged, as we have to address the issue of performance tuning after the cluster has been enabled and stabilized.
    So any tip's, tricks and suggestions to make our first (of many) SQL clusters a success would be greatly appreciated.

    Thanks in advance....
    Regards,
    Randerso




    "Education is not the filling of a pail, but the lighting of a fire." W. B. Yeats

  • #2
    Re: SQL 2005 Enterprise cluster memory amount vs page file

    i would suggest using Idera software's SQL monitoring program for this.

    its a great tool, and you an get a 30 day full-function copy that will give you a better idea of what you are looking for without having to mess with the profiler or perfmon.

    http://www.idera.com/
    its easier to beg forgiveness than ask permission.
    Give karma where karma is due...

    Comment


    • #3
      Re: SQL 2005 Enterprise cluster memory amount vs page file

      Thank you for the assist James, I'll follow up with you shortly and let you know how the app worked for us.

      Again, many thanks...
      Regards,
      Randerso




      "Education is not the filling of a pail, but the lighting of a fire." W. B. Yeats

      Comment

      Working...
      X