MSSQLThe error occurs as a result of connection leaks in the application.Photo by panumas nikhomkhai from PexelsAny applications getting connection timeouts to MS-SQL Server will see the following error.Message=Timeout expired. The timeout period elapsed prior to obtaining a connection from the pool. This may have occurred because all pooled connections were in use and the max … Continue reading Connection Leak in MSSQL
How to start MSSQL profiling?
SQLAfter installation, start SSMS & connect to the default database.Step 1: From the top toolbar, go to toolsStep 2: Select SQL server profilerStep 3: New window will open & select the default databaseStep 4: New trace properties dialogue will be opened as shown belowPlease provide details likeTrace NameSelect all events or default from Event selection tabAll columns or choose … Continue reading How to start MSSQL profiling?
MSSQL Profiling Extended Events
SQL SERVERExtended events enable users to collect data to troubleshoot or identify performance problems. It is a lightweight performance monitoring tool that uses minimal resources.By using extended events, you can see the details of the internal operations of the SQL system & your application.Demonstration of Extended EventsFollowing preliminaries are required to begin with the presentation:SSMS (SQL … Continue reading MSSQL Profiling Extended Events
C# 