THE SQL Server Blog Spot on the Web

Welcome to - The SQL Server blog spot on the web Sign in | |
in Search

Browse by Tags

All Tags » troubleshooting   (RSS)
Showing page 1 of 7 (64 total posts)
  • Managing the errorlog file

    I frequently see recommendations to regularly run sp_cycle_errorlog, so that the errorlog doesn't become huge. My main concern with that is that the errorlog contains valuable information. When I do a health check on a SQL Server machine, I want a few months worth of errorlog information available. I typically use my own scripts for this, ...
    Posted to Tibor Karaszi (Weblog) by TiborKaraszi on October 22, 2015
  • ICYMI: Partitioning Advice, Purging Data Bloat, and an example of TVF Misbehavior - SQL Server Performance

    Here are some oldies, but goodies that I recommend you read:Two Partitioning Peculiarities and Aggregates and PartitioningMost of us know that partitions are one of the best ways to scale very large databases or very large IO workloads.  However, there are risks, two of which are explored in detail by internals master Paul White ...
    Posted to Kevin Kline (Weblog) by KKline on March 30, 2015
  • ICYMI: Troubleshooting CPU, Logging Myths, Missing Indexes, and Query Tuning Examples

    Great Articles at SQLPerformance.comThere are so many good articles from this ICYMI article that it’s hard to know which are best to highlight in the limited space. So, I’ll be arbitrary and simply choose a few of my favorite entries as we look back:Troubleshooting SQL Server CPU Performance IssuesThis outstanding ...
    Posted to Kevin Kline (Weblog) by KKline on March 16, 2015
  • ICYMI: Troubleshooting Availability Groups and the Schema Switcharoo - SQL Server Performance

    Aaron Bertrand (b | t) is on a roll this month's SQL Server performance highlights with more great articles from Troubleshooting AlwaysOn – Sometimes it takes many sets of eyesAaron Bertrand (b | t) hit some obstacles recently when configuring an Availability Groups lab environment. This post ...
    Posted to Kevin Kline (Weblog) by KKline on March 9, 2015
  • Top 10 DBA Mistakes on SQL Server. (Now with Prizes for Participation!)

    The first big mistake I made as a DBA was coming to work with my zipper wide open. But I digress.Hear one of my most popular session via streaming media at SQLSentry.TV!Microsoft SQL Server is easier to administrate than any other relational database on the market.  But “easier than everyone else” doesn’t mean it’s easy.  And it doesn’t ...
    Posted to Kevin Kline (Weblog) by KKline on April 9, 2014
  • Does your 3:rd party backup software ruin your SQL Server backup plan?

    Sounds scary, huh? And it surely can be! Here’s an example of one such case: A client of mine had implemented a 3:rd party backup solution in their VM Ware environment. This shouldn't affect the SQL Server backups. Or that was the plan. I won’t mention what backup software this is, since I’m sure that there are other software also doing ...
    Posted to Tibor Karaszi (Weblog) by TiborKaraszi on April 8, 2014
  • Unexpected SPID change

    A few time ago I had the opportunity to investigate about an unexpected SPID (Session Process ID) change. The inquiry began when a customer of ours starts to complain for locks, and lock time out error. These locks sometime were more frequent and sometimes not. To investigate about this issue, I have taken two SQL Profiler trace files ...
    Posted to Sergio Govoni (Weblog) by Sergio Govoni on April 3, 2014
  • Performance Tuning with SQL Server Dynamic Management Views

    From Red-Gate website you can download (for free) the ebook Performance Tuning with SQL Server Dynamic Management Views written by Louis Davidson (@drsql) and Tim Ford (@sqlagentman). DMVs are objects that publish information about the health state of a SQL Server instance. They allow you to monitor the heart of the system to diagnose ...
    Posted to Sergio Govoni (Weblog) by Sergio Govoni on March 14, 2014
  • Troubleshooting Clusters

    The session Troubleshooting Clusters by Allan Hirt (@SQLHA) has been published on channel SQLPASS TV. Abstract Whether you are new to clusters or have years of experience, you may still cross your fingers when implementing a failover cluster instance (FCI) of SQL Server or an availability group (AG). Both require an underlying Windows Server ...
    Posted to Sergio Govoni (Weblog) by Sergio Govoni on February 23, 2014
  • One Preparation that makes SSMS Crash Dumps Easy to Survive

     Uh oh!So you're plugging along in SQL Server Management Studio (SSMS) when it suddenly goes belly up. Now you're staring at various dialog boxes telling you that SSMS crashed. Usually the first dialog box you get will ask you if you'd like to close OR the program. If you choose to close the program, you'll be presented with the opportunity ...
    Posted to Kevin Kline (Weblog) by KKline on February 10, 2014
1 2 3 4 5 Next > ... Last »
Powered by Community Server (Commercial Edition), by Telligent Systems
  Privacy Statement