Here's a quick tip for you: During some restore operations on Microsoft SQL Server, the transaction log redo step might be taking an unusually long time. Depending somewhat on the version and edition of SQL Server you've installed, you may be able to increase performance by tinkering with the readahead performance for the redo operations. To do this, you should use the MAXTRANSFERSIZE parameter of the RESTORE statement. For example, if you set MAXTRANSFERSIZE=1048576, it'll use 1MB buffers. If you change the MAXTRANSFERSIZE, keep an eye on the PerfMon objects for Buffer Manager and … [Read more...]
Quick Tip – Speed a Slow Restore from the Transaction Log
Filed Under: Databases, IO, Performance, SQLMag, SQLServerPedia Syndication, Tips & Tricks Tagged With: Backup & Recovery, DBA, Internals, SQL Server 2012
The Zombie PerfMon Counter That Never Dies! Quick Tip
The PerfMon Counters That Just Won't Die One of the things that's simultaneously great and horrible about the Internet is that once something gets posted out in the ether, it basically never goes away. (Some day, politicians will realize this. We can easily fact check their consistency). Because of longevity of content posted to the Internet, a lot of performance tuning topics become "zombies". We shoot 'em in dead, but they keep coming back! In other words, those old recommendations were a suggested best practices for long ago, for a specific version of SQL Server, but are now … [Read more...]
Filed Under: Challenges, Databases, IO, Performance, SQL Server, SQLMag, SQLServerPedia Syndication, Tips & Tricks Tagged With: Best Practices, DBA, Developer, DMV, Monitoring, Troubleshooting
Two New Slide Decks. Plus, the Week in Colorado.
I had the honor of traveling the great state of Colorado last week, speaking at the PASS chapters in Boulder, Colorado Springs, and Denver. At all three events, we had a stellar attendance and, at least in Denver, broke all the records in recent memory both in terms of overall attendance and in first-timers. Denver, in fact, was standing room only and had nearly 30 first time attendees. Great news! I also want to give a special shout-out of thanks and appreciation to Chris Shaw (Twitter | Blog) whose hard work and tenacity ensured that all of Colorado got to see me speak. From left to … [Read more...]
Filed Under: Administration, Challenges, Cool Technologies, Databases, IO, On-Line Resources, PASS, Presentations, Professional Development, SQL Server, SQLMag, SQLServerPedia Syndication, Tips & Tricks, Video Tagged With: Best Practices, CodePlex, DBA, Developer, Leadership, Performance, SQL Server 2012, SQLSaturday, Tools & Scripts, Troubleshooting, Video
Accelerate OLTP with HP and Microsoft’s New High Performance Reference Architecture
If you haven't started to read Shashank Pawar (blog), you're missing out. Shashank is part of Microsoft Australia and has been writing some very good content lately. Here's an example from the Reference Architecture for High Performance SQL Server: HP and Microsoft engineering teams have worked together to create a reference architecture to Accelerate Online Transaction Processing (OLTP) database workloads with a fully-flash based HP/Microsoft architecture and achieve significant performance increases, simplified database manageability, and industry leading TCO. The details come in a … [Read more...]
Filed Under: Architecture, Challenges, Cool Technologies, Databases, Hardware, IO, Performance, SQL Server, SQLMag, SQLServerPedia Syndication Tagged With: DBA, Oracle, Performance
New on “Database Trends & Applications”
In last month's column, "2012 Might Really Be the End of the World as We Know It," I described a number of major developments in the IT industry that are likely to disrupt the life of database professionals everywhere. I categorize those four disruptors - virtualization, cloud computing, solid state drives (SSD), and advanced multi-core CPUs - into two broad groups. I'm going to continue an analysis of these disruptive technologies in inverse order. Today, let's discuss SSDs. [READ MORE ON DATABASE TRENDS & APPLICATIONS ] … [Read more...]
Filed Under: Administration, Challenges, Cool Technologies, Databases, IO, Opinion, SQL Server, SQLMag, SQLServerPedia Syndication, Virtualization Tagged With: Best Practices, Career, DBA, DBTA, Developer, FutureWatch, Goals, Virtualization
What I’m Reading, July 22 2011
I read too much, and that, my friends, is an entirely separate topic for a blog post. But I thought I'd share with you a little more about what I'm reading because sometimes, if I'm lucky, it might be something you'd enjoy too. So I'm going to start sharing what I'm reading at least once per week, partly so that I don't firehose too many reading links directly into your brain (where I to do it say once per month) and partly to solidify in my own mind the information that I'm reviewing. So here are a few good links for the seven days leading up to July 22, 2001: Microsoft and Whitehouse … [Read more...]
Available Online – SQL Server Training Videos
Interested in my various performance tuning and troubleshooting videos about SQL Server? These videos feature my good buddies (and uber-SQL Server experts) Brent Ozar (blog | twitter) and Buck Woody (blog | twitter). View these insight-packed training videos from our SQL Server training events originally presented on March 3 and July 21 of 2010:HERE. You can watch the videos now at the URL above or order a DVD, shipped free of charge in the USA and Canada, HERE. Enjoy! -Kev ~~~ Twitter at kekline More content on my Blog … [Read more...]
Filed Under: Administration, Challenges, Databases, IO, On-Line Resources, Performance, SQL Server, SQLMag, SQLServerPedia Syndication Tagged With: Best Practices, DBA, DMV, Internals, Monitoring, Performance, Quest Software, SQL Server 2008 R2, Video
Come Aboard. We’re Expecting You
Those of us over a certain age (read - old as dirt) can remember the theme songs to certain TV shows better than we can the National Anthem. Try these lines out and see if you don't immediately remember the tune that goes along with them: Come and knock on our door | We've been waiting for you ... Makin' your way in the world today | Takes everything you've got ... Just some good ol' boys | Never meaning no harm ... Thank you for being a friend | Travel down the road and back again ... So when I got the news that my employer, Quest Software, wanted to send one of the team to an … [Read more...]
Filed Under: IO, SQL Server, SQLMag, SQLServerPedia Syndication Tagged With: Best Practices, Professional Development, SQL Server 2008 R2, Training
Wednesday Quest: On-Line Demos for Toad Data Analyst and Benchmark Factory
If you've attended any of my public sessions about SQL Server technology, then you might remember that I extend a standing offer to provide a free, long-term license to any of several products from Quest Software, such as Toad for SQL Server (including the SQL Optimizer), Toad Data Analyst, Toad Data Modeler, and the awesome performance and scalability testing tool Benchmark Factory. If you've ever wondered about these tools and why I tout them, why don't you take a couple minutes to look at the on-line demos available at each of the preceding links? If you like what you see, drop me a … [Read more...]
Filed Under: Administration, Cool Technologies, IO, Performance, SQL Server, Tool Time Tagged With: DBA, Developer, Quest Software, Tools
Video: Magic Formula for SQL Query Tuning
Featuring Kevin Kline this video focuses on accelerated Disk Optimization and improved productivity with SQL Query Tuning. Posted December 18, 2006. … [Read more...]
Filed Under: IO, Performance, Presentations, SQL Server, SQLServerPedia Syndication, Tips & Tricks, Video Tagged With: DBA, Performance, Query Tuning, SQL Server 2005, Troubleshooting, Video, Web Development
