How to change configuration setting when your SQL Server instance cannot start

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:
FacebooktwitterredditpinterestlinkedintumblrmailFacebooktwitterredditpinterestlinkedintumblrmail

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.

-Marek

Share it:
FacebooktwitterredditpinterestlinkedintumblrmailFacebooktwitterredditpinterestlinkedintumblrmail

By continuing to use the site, you agree to the use of cookies. more information

The cookie settings on this website are set to "allow cookies" to give you the best browsing experience possible. If you continue to use this website without changing your cookie settings or you click "Accept" below then you are consenting to this.

Close