Product was added to your cart
YouTube
GitHub

Production Database Administration

  1. Home
  3. Production Database Administration
    4. (Page 4)

Checking for Strange Client Settings with sys.dm_exec_sessions

Brent Ozar
Configuration Settings, Indexing
11 Comments
In my performance training class, people get really excited when I cover filtered indexes, computed columns, and indexed views. Then they get a really strange expression on their face when I talk about one of the biggest drawbacks: if your connection options aren’t set correctly, your delete/update/insert (DUI) operations will fail. That gave me a really…
Read More

What is Batch Requests/sec?

Tara Kizer
Load Testing, Monitoring
39 Comments
When I first look at a server, I want to know how busy it is, where its bottlenecks are, what is SQL Server waiting on and many other things. Batch Requests/sec is one of the data points that is used to measure how busy a server is. WHAT IS BATCH REQUESTS/SEC? Batch Requests/sec is a performance counter…
Read More

Analyzing Temporary Stored Procedures with sp_BlitzCache

Erik Darling
First Responder Kit, sp_BlitzCache, TempDB
, , ,
2 Comments
All the cool kids Know that when you’re trying to figure out why a stored procedure is slow sometimes, you should use a temporary stored procedure instead of pulling the code out and running it ad hoc. We frequently point people to Erland Sommarskog’s “Slow in the Application, Fast in SSMS“, because it’s an excellent…
Read More

Ten Ways to Set MAXDOP

Brent Ozar
Configuration Settings
9 Comments
Whenever I work with SQL Server, I’m amazed at how many ways there are to influence its behavior. For example, take the maximum degree of parallelism for a query. Just offhand, I thought of ten different ways you can tweak it: 1. At the server level with SSMS. In SSMS, right-click on the server, click Properties, Advanced,…
Read More

Availability Groups: More Planned Downtime for Less Unplanned Downtime

Brent Ozar
Always On Availability Groups, Breaking News, SQL Server
,
9 Comments
I often hear companies say, “We can never ever go down, so we’d like to implement Always On Availability Groups.” Let’s say on January 1, 2016, you rolled out a new Availability Group on SQL Server 2014. It’s the most current version available at the time, and you deploy Service Pack 1, Cumulative Update 4 (released…
Read More

Breaking News: 2016 Query Store cleanup doesn’t work on Standard or Express Editions

Brent Ozar
Breaking News, First Responder Kit, Query Store (QDS), SQL Server
5 Comments
If you’re using SQL Server 2016’s awesome new feature, Query Store, there’s a new bug with automatic cleanup. Books Online explains: Automatic data cleanup fails on editions other than Enterprise and Developer. Consequently, space used by the Query Store will grow over time until configured limit is reached, if data is not purged manually. If…
Read More

Creating Tables and Stored Procedures in TempDB – Permanently

Brent Ozar
Bad Idea Jeans, Humor, SQL Server, TempDB
37 Comments
No, not #tables – actual tables. Here’s how: Transact-SQL USE tempdb; GO /* This one is only available during my session: */ CREATE TABLE #myTempTable (ID INT IDENTITY(1,1), Stuffing VARCHAR(100)); GO /* This one is global, meaning it's available to other sessions: */ CREATE TABLE ##myTempTable (ID INT IDENTITY(1,1), Stuffing VARCHAR(100)); GO /* You can…
Read More
Menu
{"cart_token":"","hash":"","cart_data":""}