Instead, I’ll run amazing tool, sp_WhoIsActive, and I’ll show you my favorite parameters. How to see what queries are running: sp_WhoIsActive – during the webcast, I’ll want to see what queries are causing me problems right now, and I won’t be firing up Activity Monitor. I publish small (10GB), medium (50GB), and large (312GB) versions. How to run demos: Stack Overflow database – the popular Q&A site gives away your questions, answers, comments, etc in an open format, and I import it into a SQL Server database you can use for learning T-SQL and indexing. In the webcast, I’ll be using a set of free random workload scripts which run against the… How to run a load tests: SQLQueryStress – an open source app originally written by Adam Machanic, and now maintained by Erik Ejlskov Jensen on Github. In a one-hour session today for the PASS DBA Fundamentals online user group (free to join, of course), I showed some off. The SQL Server community has banded together and built a bunch of cool stuff to help you do your job easier. You’re responsible for managing and troubleshooting SQL Server.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |