This chapter covers the use of Performance Monitor (perfMon) counters, DMOs, wait stats, SQL trace, Extended Events (XE), and Query Store. In each case, details of what to collect, their meaning and ...

One way that organizations are storing data in the cloud is by moving their databases to the cloud. What once meant building an entire physical server, patching it, installing software like Microsoft ...

If you're considering moving your on-premises SQL Server databases to the Microsoft Azure cloud, you need to decide which of the different cloud options works best for you. You might not realize it to ...

If you are an old hand at Microsoft SQL Server, you have probably used the SQL Server Agent (i.e., SQL Agent) service and MSDB database for the last 20 years. With a humble and largely unchanged ...