Home

Impact of SSD Disk over HDD on MSSQL Performance

Impact of SSD Disk over HDD on MSSQL Performance

Recently our server where MSSQL Server database resides was upgraded and SSD disk was installed. Let us understand the performance improvement on different processes of SQL Server where it had positive impact and where it didn’t have much. Sudden Improvement was observed at below Proesses: Backup of database Maintenance Job Report Generation Database Consistency CHECKDB …

Impact of SSD Disk over HDD on MSSQL Performance Read More »

What If Mismatched Instance Name & Port - Which One Takes Precedence

What If Mismatched Instance Name & Port – Which One Takes Precedence

This scenario could be faced by someone who is having multiple instances running on the same server. Mostly we try to have dedicated server for Production environment however for Test environments(SIT, UAT, Dev) – Based on criticality of application, we tend to install multiple instances of SQL Server on the same server. As you are …

What If Mismatched Instance Name & Port – Which One Takes Precedence Read More »

Why Index Hints Should Never Be Used(My Experience)

Why Index Hints Should Not(judiciously) Be Used(My Experience)

I am sharing here my recent experience with one of our vendor who is considered as very much reputed and experienced, they have team of DBAs(development DBA cum Architect, Production DBA, Infrastructure DBA etc..) and mostly their database codes as well as their indexing are not disputable. I am the lonely DBA working in my …

Why Index Hints Should Not(judiciously) Be Used(My Experience) Read More »