What Performance counters will you use to set up SQL Server baseline ? Setting up SQL Server baseline is primary objective for every DBA. This baseline will be key during troubleshooting performance issues. A DBA should setup up a server base by using the following performance counters. S. No Counter Name Description 1 Memory\Available Bytes [...]
Category Archives: Windows
What Performance counters will you use to set up SQL Server baseline ?
Posted by Mahesh Gupta on July 8, 2011
1 comment
Part 9: Implement & Test Virtual Name
Posted by Mahesh Gupta on February 4, 2011
0 comments
In this series of Videos Prakash Heda (Sr Infrastructure DBA at Intuit) will cover how to prepare one box HyperV lab to updaerstand and validate SQL Server Denali Always-ON Features Let me know how do you like this series and any specific questions you have, My contact email: prakash@sqlfeatures.com, Blog: sqlfeatures.wordpress.com Part 1: Denali setup & Network Configuration Part 2: Configure Windows 2008 R2 Domain Controller Part 3: Preparing nodes for failover cluster Part 4: Configure 2 node failover cluster Part 5: Install Standalone Denali on both nodes Part 6: Denali Availability Groups Explained (Session 1) Part 6: Denali Availability Groups Explained (Session 2) Part 6: Enable availability Groups (Session 3) Part 7: Configure Availability Groups with 2 DB’s Part 8: Readable replica & test force failover Part 9: Implement & Test Virtual Name
Part 8: Readable replica & test force failover
Posted by Mahesh Gupta on February 4, 2011
0 comments
In this series of Videos Prakash Heda (Sr Infrastructure DBA at Intuit) will cover how to prepare one box HyperV lab to updaerstand and validate SQL Server Denali Always-ON Features Let me know how do you like this series and any specific questions you have, My contact email: prakash@sqlfeatures.com, Blog: sqlfeatures.wordpress.com Part 1: Denali setup & Network Configuration Part 2: Configure Windows 2008 R2 Domain Controller Part 3: Preparing nodes for failover cluster Part 4: Configure 2 node failover cluster Part 5: Install Standalone Denali on both nodes Part 6: Denali Availability Groups Explained (Session 1) Part 6: Denali Availability Groups Explained (Session 2) Part 6: Enable availability Groups (Session 3) Part 7: Configure Availability Groups with 2 DB’s Part 8: Readable replica & test force failover Part 9: Implement & Test Virtual Name
Part 7: Configure Availability Groups with 2 DB’s
Posted by Mahesh Gupta on February 4, 2011
0 comments
In this series of Videos Prakash Heda (Sr Infrastructure DBA at Intuit) will cover how to prepare one box HyperV lab to updaerstand and validate SQL Server Denali Always-ON Features Let me know how do you like this series and any specific questions you have, My contact email: prakash@sqlfeatures.com, Blog: sqlfeatures.wordpress.com Part 1: Denali setup & Network Configuration Part 2: Configure Windows 2008 R2 Domain Controller Part 3: Preparing nodes for failover cluster Part 4: Configure 2 node failover cluster Part 5: Install Standalone Denali on both nodes Part 6: Denali Availability Groups Explained (Session 1) Part 6: Denali Availability Groups Explained (Session 2) Part 6: Enable availability Groups (Session 3) Part 7: Configure Availability Groups with 2 DB’s Part 8: Readable replica & test force failover Part 9: Implement & Test Virtual Name
Part 6: Enable availability Groups (Session 3)
Posted by Mahesh Gupta on January 31, 2011
0 comments
In this series of Videos Prakash Heda (Sr Infrastructure DBA at Intuit) will cover how to prepare one box HyperV lab to updaerstand and validate SQL Server Denali Always-ON Features Let me know how do you like this series and any specific questions you have, My contact email: prakash@sqlfeatures.com, Blog: sqlfeatures.wordpress.com Part 1: Denali setup & Network Configuration Part 2: Configure Windows 2008 R2 Domain Controller Part 3: Preparing nodes for failover cluster Part 4: Configure 2 node failover cluster Part 5: Install Standalone Denali on both nodes Part 6: Denali Availability Groups Explained (Session 1) Part 6: Denali Availability Groups Explained (Session 2) Part 6: Enable availability Groups (Session 3) Part 7: Configure Availability Groups with 2 DB’s Part 8: Readable replica & test force failover Part 9: Implement & Test Virtual Name
Part 6: Denali Availability Groups Explained (Session 2)
Posted by Mahesh Gupta on January 31, 2011
0 comments
In this series of Videos Prakash Heda (Sr Infrastructure DBA at Intuit) will cover how to prepare one box HyperV lab to updaerstand and validate SQL Server Denali Always-ON Features Let me know how do you like this series and any specific questions you have, My contact email: prakash@sqlfeatures.com, Blog: sqlfeatures.wordpress.com Part 1: Denali setup & Network Configuration Part 2: Configure Windows 2008 R2 Domain Controller Part 3: Preparing nodes for failover cluster Part 4: Configure 2 node failover cluster Part 5: Install Standalone Denali on both nodes Part 6: Denali Availability Groups Explained (Session 1) Part 6: Denali Availability Groups Explained (Session 2) Part 6: Enable availability Groups (Session 3) Part 7: Configure Availability Groups with 2 DB’s Part 8: Readable replica & test force failover Part 9: Implement & Test Virtual Name
Part 6: Denali Availability Groups Explained (Session 1)
Posted by Mahesh Gupta on January 31, 2011
0 comments
In this series of Videos Prakash Heda (Sr Infrastructure DBA at Intuit) will cover how to prepare one box HyperV lab to updaerstand and validate SQL Server Denali Always-ON Features Let me know how do you like this series and any specific questions you have, My contact email: prakash@sqlfeatures.com, Blog: sqlfeatures.wordpress.com Part 1: Denali setup & Network Configuration Part 2: Configure Windows 2008 R2 Domain Controller Part 3: Preparing nodes for failover cluster Part 4: Configure 2 node failover cluster Part 5: Install Standalone Denali on both nodes Part 6: Denali Availability Groups Explained (Session 1) Part 6: Denali Availability Groups Explained (Session 2) Part 6: Enable availability Groups (Session 3) Part 7: Configure Availability Groups with 2 DB’s Part 8: Readable replica & test force failover Part 9: Implement & Test Virtual Name
