SQL Server has a very good store of data about your SQL Server operations that you can gather for trending. These include index usage, index operational, disk space, database space, etc. In this session you'll first learn the basics of what this data is and what it can be used for. Second you will see the solution I have developed to gather this information, as well as how you can modify it to get more data very simply. And last you will see some data I've gathered and reports that show you what your environment is like. You will learn how simple it is to get a wealth of information using my favorite tool (PowerShell) and hopefully it will become yours. If you are interested in operational insights into what is happening in your database and how simple it is to gather this data, this session is for you. You will get all demo scripts. This session is demo heavy so come hungry.
No material found.