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 »
First of all, Let me state it upfront that hinting index is not a very good idea and could result in degraded performance. Index hint is not actually a hint rather we are ordering Database Engine to use the provided index however it is still called as “Hint”. In one of my earlier post, I …
Index Hint – Index Is Dropped By DBA, What Will Happen Now? Read More »
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 »
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 »