Search Results for “Ola Hallengren”

  1. Home
  2. Search Results
  3. (Page 4)
Pocket Square

Backing Up to Same Drive Where Databases Reside

Blitz Result: Backing Up to Same Drive Where Databases Reside BUT I’M TAKING BACKUPS! Yes, and thank you for doing that. But you shouldn’t be doing it where you databases live. Here’s why: You’re eating up disk I/O, even if it’s not during client-facing windows, it’s likely during other maintenance (DBCC CHECKDB, Index and Statistics,…
Read More

Backing Up an Oracle Database

One of a DBA’s most important tasks is taking backups of databases. As SQL Server DBAs, we’re used to using the same tools to backup the database that we use for the rest of our job. With Oracle, there are two main ways to back up a database: user managed backups and Oracle Recovery Manager (RMAN).…
Read More
Plan Guides are like duct tape

Stabilizing Execution Plans: Plan Guides and NORECOMPUTE

What could go wrong? Sometimes you end up in a good plan / bad plan situation: an important query runs just fine most of the time. The query is parameterized, a good execution plan gets re-used, everything is cool. But sometimes, a “bad plan” gets compiled and starts to be reused. This is “bad” parameter sniffing. “Bad plans” can…
Read More
Pocket Square

Merge Replication with Infinite History

sp_Blitz Result: Merge Replication with Infinite History When merge replication is in use it creates a number of metadata/tracking tables that store the changes to your replicated tables. These change tracking tables can get very large so SQL Server helpfully trims them on your behalf after a time that you can set – this time…
Read More
Pocket Square

DBCC CHECKDB Not Run Recently

When SQL Server writes data to your drives, it just assumes everything’s okay until it needs to read the data back again. Unfortunately, in the event of storage corruption, the storage isn’t so kind as to alert SQL Server.  And sometimes, SQL Server has even been known to corrupt itself. We need to periodically check…
Read More

SQL Server RDS

Amazon Web Services (AWS) is a platform that offers a ton of services ranging from block storage, operating systems, to mail queues, DNS, and caching. When you say “cloud”, a lot of people think of AWS. AWS hosts a variety of businesses, large and small. Unfortunately, you still have to administer and configure your servers.…
Read More
Pocket Square

Full Recovery Model Without Log Backups

6 Comments
Full Recovery Model Without Log Backups When a database is in Simple Recovery Model, SQL Server does circular logging: it goes back to the beginning of the transaction log and reuses space when it can.  Portions of the log are freed up when they’re not covering open transactions. Circular use of the transaction log file…
Read More
Pocket Square

Backups Not Performed Recently

Backups Not Performed Recently Errr…… Before we start working on anything, we need to know all our user databases are getting backed up.  We check to see if there’s been a full backup in the last 7 days. Often, someone set up maintenance plans to back up specific databases by checking their names.  They checked…
Read More
Menu
{"cart_token":"","hash":"","cart_data":""}