Book Image

PowerShell for SQL Server Essentials

By : Donabel Santos
Book Image

PowerShell for SQL Server Essentials

By: Donabel Santos

Overview of this book

Table of Contents (15 chapters)
PowerShell for SQL Server Essentials
Credits
About the Author
Acknowledgments
About the Reviewers
www.PacktPub.com
Preface
Implementing Reusability with Functions and Modules
Index

Current server resources


One of the first things you might want to check out before profiling SQL Server instances is the general health of the server. There are a number of metrics you can check, but usually there are four that you almost always need to check first: processor usage, available disks and their usage, available memory and its usage, and the network.

The Task Manager option in Windows can often provide a good at-a-glance view of resources. One way to launch this tool is by right-clicking on the task bar and selecting Task Manager, as shown in the following screenshot:

When the Task Manager window comes up, you can select the Processes tab to see the CPU and memory usage right away. The following screenshot shows what Task Manager looks like in Windows Server 2012 R2. This window will look slightly different if you are using a different Windows version:

This window can provide a very quick way to figure out which processes are taking up the most CPU or memory. You can click on...