Category Archives: Windows

What Performance counters will you use to set up SQL Server baseline ?

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 [...]

Part 9: Implement & Test Virtual Name

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

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

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)

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)

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)

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