Archive for the ‘parameter sniffing’ Tag

Query Store: Exploring new features in SQL Server – vNext   1 comment

Troubleshooting performance problem is one of the challenging and most often faced situation in DBA’s life. Following diagram shows three major scenarios where DBA’s get involved and spend nights troubleshooting performance problems.

Note: This is with community technical preview 2 of SQL Server 2016, things may change with the RTM release

18

Read the rest of this entry »