What are the important points to remember while setting up HADR in SQL Server 2022?

Thursday, May 2, 2024 |

 It's been more than a decade I wrote an article that too on the LinkedIn....

Compatibility and Upgrade: Ensure that your SQL Server environment is compatible with SQL Server 2022 and plan for any necessary upgrades or migrations.

HADR Options: Explore the HADR options available in SQL Server 2022, such as Always On Availability Groups, Failover Cluster Instances, and Database Mirroring, to determine the best fit for your requirements and the SQL Server edition your company is owning.

Server and Network Redundancy: Set up redundant servers, storage, and network components to minimize single points of failure and ensure high availability.

Interesting!? Continue reading it at here.

blog.extreme-advice.com is new blog home for me

Tuesday, October 16, 2012 |

SQLHub.com is my favorite domain name and I love SQL Server so I started this blog few years back. I still like SQL Server very much but now I am thinking to share my knowledge in SQL Server along with other technology too and that why I have booked new domain http://www.extreme-advice.com/ and started new technology blog at http://blog.extreme-advice.com/.

SQLHub.com will not have my new articles now so I would like to request my blog readers, please update your book mark with my new blog http://blog.extreme-advice.com/. You can even subscribe to new blog, there is text box given for subscription in http://blog.extreme-advice.com/ at center-right side of the blog.

You can even drop by face book page of extreme-advice.com. Have a look at Facebook page of Extreme-Advice.

Enjoy Reading !!!!

Reference: Ritesh Shah
Quick Learn
Note: Microsoft Books online is a default reference of all articles

Extreme-Advice : Analyze IO disk pressure in SQL Server

Monday, October 15, 2012 |

Before we move further, have a look at my following article as we are going to use the script given in that article:

Find Disk performance with sys.Dm_io_virtual_file_stats in SQL Server
I have already provided the script to display Disk IO waits in above given article, now we will further enhance that process.

By looking at IO Stall given in above article, can’t help us much. We should have data captured for few hours or may be a few days so that we can have details like which time/day we get high number of stall, we can find pattern of IO based on the statistics we capture for few hours/days. Now question comes into the picture, how can we do it with help of script given in “Find Disk performance with sys.Dm_io_virtual_file_stats in SQL Server” article?

Well we have to enhance the script give there. Let us start our journey to capture pattern of IO.

Click here to read complete article.

Extreme-Advice : Find Disk performance with sys.Dm_io_virtual_file_stats in SQL Server

Friday, October 12, 2012 |

“sys.Dm_io_virtual_file_stats” is one of the excellent DMV in SQL Server. Generally people used talk about processor, memory and network a lot but always overlook disk capacity. You can’t read/write more than the capacity of your disk, no matter how many processor/core you have, how much RAM you assign to SQL Server or how fast your network is.
Whenever I have a situation to deal with performance issue of SQL Server, I never forget to use “sys.Dm_io_virtual_file_stats” DMV. I have very small script but it can save so many hours which you suppose to spend in finding a bottleneck of performance in SQL Server whenever disk is a culprit.

Each disk has capacity to read and write, if your workload is generating more read/write then the capacity of your disk, you can’t achieve optimal performance of other hardware you have.
Here is the script to measure disk IO capacity, have a look at it:

Click here to read complete article:

Extreme-Advice : Performance Counter in Microsoft Windows Server 2008


Performance Counter in Microsoft Windows Server 2008 :

As I have promised in my article “Performance Counter in SQL Server“, herewith, I am providing introduction about how to run Performance Counter from Microsoft Windows?
As a Database Administrator or System Administrator, you always have responsibility to monitor system performance, find bottleneck of performance which may be related to network, disk, memory, IIS, SQL Server and much more. Each admin have different responsibility to monitor different part of system, depends of the domain s/he working one. These monitoring responsibility can greatly  be done with help of Performance Counter as it cater the needs of DBA, System Admin, IIS Admin and much more.

You can create your own “Data Collector Set” in “Performance Counter” with the counters you need. You have variety of choices to select in form of counter. some of the important counters are as follows:

Click Here to read complete article.