Help! My SQL Server Maintenance Takes Too Long!

We are pleased to welcome Brent Ozar as our guest speaker!

You manage growing SQL Server databases with shrinking nightly maintenance windows. You just don't have enough time left each night to do the necessary backups, corruption checking, index maintenance, and data jobs that your users and apps want to run. Cloud storage isn't helping the problem, either.

Stop playing Tetris with your job schedules and step back for a second: are we doing the right things, at the right times, with the right SQL Server configuration?

In this session, Brent  will give you three queries to run on your SQL Server to make sure you're focused on the right problems. We'll figure out how fast your backups are really going (and why), whether nightly index maintenance actually makes sense for you or not, and whether your hardware is suffering from serious performance issues.

2021-02-16T09:00:00.000-05:00

Brent Ozar - Founder/Owner, Brent Ozar Unlimited

Brent got his start in the late 1990s – first as a developer and systems administrator, then as a full time DBA. He's managed performance and reliability for truly tough servers: tens of terabytes, thousands of databases, thousands of queries per second. He's one of the rare Microsoft Certified Masters, and he's taught at conferences around the world including the PASS Summit, SQLbits, SQL Intersections, and Microsoft Ignite.

Argenis Fernandez

Principal Field Solutions Architect, Pure Storage
Continue Watching
We hope you found this preview valuable. To continue watching this video please provide your information below.
800-379-7873 +44 20 3870 2633 +43 720882474 +32 (0) 7 84 80 560 +33 9 75 18 86 78 +49 89 12089 253 +353 1 485 4307 +39 02 9475 9422 +31 (0) 20 201 49 65 +46-101 38 93 22 +45 2856 6610 +47 2195 4481 +351 210 006 108 +966112118066 +27 87551 7857 +34 51 889 8963 +41 31 52 80 624 +90 850 390 21 64 +971 4 5513176 +7 916 716 7308 +65 3158 0960 +603 2298 7123 +66 (0) 2624 0641 +84 43267 3630 +62 21235 84628 +852 3750 7835 +82 2 6001-3330 +886 2 8729 2111 +61 1800 983 289 +64 21 536 736 +55 11 2655-7370 +52 55 9171-1375 +56 2 2368-4581 +57 1 383-2387