Recently one of my colleagues asked me for help with his SQL Server instance. He made a mistake while configuring Maximum Server Memory and his instance was not able to run because of wrong memory settings. He set it to low 10MB instead of 10GB. I was working on customer related issues which couldn’t wait, so I asked other DBA to help him with this. Of course everything was fixed in a few minutes. Later I realized that’s good topic for my next blog post. So it is… Continue reading “How to change configuration setting when your SQL Server instance cannot start”Share it:
Month: September 2017
SQL Saturday #664 -Troubleshoot SQL Server performance problems like a Microsoft Engineer
This Saturday I had great pleasure to be part one of the greatest SQL Server community event: SQL Saturday 664. It is a free training event for Microsoft Data Platform professionals and those wanting to learn about SQL Server, Business Intelligence and Analytics. This time we met in Katowice in Poland.
I had an amazing occasion to present my session about Tools used by Microsoft engineers for SQL Server performance troubleshooting.
Here you can find my slide deck: SQLSaturday 664 – Troubleshoot SQL Server performance problems like a Microsoft Engineer
I also posted it on my slideshare profile.