SQLAuthority News – SQL Server Health Check Service – Speed UP SQL Server

In my earlier article SQLAuthority News – Training and Consultancy and Travel – Story of Last 30 Days I had mentioned that I prefer to do 50% consultation and 50% training. Since then I often receive what do I do consultation for and what is my expertise. I am basically man of the performance tuning. I love to tune servers and I love to speed up queries. I often get queries what do I do when I go to performance tuning. Here I am listing my complete service descriptions.

This whole exercise can be done remotely as well on site. The advantage of on site is that I am more involved with local DBAs and the training part is much more enjoyable. I have often got very good relations with the local DBA and we still talk when they have issues with server. There is no replacement of the human connections. The advantage of the remote is there is no travel involved and can be economic when the location is very remote or there is urgent need of performance.

Please read more about this service over here

SQL Server Health Check Service

SQL Server Health Check is a very challenging subject that requires expertise in Database Administration and Database Development. Solid Quality Mentors provides specialized health check service where we dive deep into your SQL Server configurations and potential issues and propose solutions to resolve your issues. We also provide maintenance scripts and train your team on few of the key areas in order to empower them to understand and tune the systems in the future. We also provide Hands-On sessions for tuning your queries and propose solutions for your deadlock situations.

Download the HealthCheck PDF details from here

If you need this service drop me an email at pinal “at” SQLAuthority.com and IndiaInfo “at” SolidQ.com. If you specify SQLAuthority.com in Title, you will avail special discount in overall rates.

Reference: Pinal Dave (http://blog.sqlauthority.com)

5 thoughts on “SQLAuthority News – SQL Server Health Check Service – Speed UP SQL Server

  1. Hi Pinal,
    The check list looks really good, a nice idea on offering packaged DBA consultation. I have a question for you in the context of log analysis, have you heard about the term log forwarding, what does that mean?

    Like

    • Hi Ramdas,

      Great question. I do not think there is something out of box available as Log Forwarding in SQL Server. Log Forwarding is the concept when forward-logging is active, all changes to a database environment since the last backup are recorded in a separate log file. In case of a disaster those changes may be applied to a previous backup, thus ensuring that no data is lost and database integrity is maintained.

      Kind Regards,
      Pinal

      Like

  2. Hi,

    You can also use SQL Server’s inbuilt DMVs to identify and help fix many performance problems.

    You can discover a lot more about DMVs in this forthcoming book http://www.manning.com/stirk. Chapter 1 can be downloaded for free and includes scripts for:

    A simple monitor
    Finding your slowest queries
    Find your missing indexes
    Identifying what SQL is running now
    Quickly find a cached plan

    Thanks
    Ian

    Like

  3. Hello Pinal,

    Running into some more trouble here.
    A server was performing pathetic. I defragmented it. There was only a single 250GB HDD. After defragmentation was done at least thrice, the MDF, file for the primary database
    failed to defrag. It still has hundreds of fragments.

    I’m sure the application performance is taking a hit due to this.
    Some knowledgeable co-worker of mine suggested that the SQL Server 2005 / 2008 Database can be defragmented from within the Management Studio, by writing a PROCEDURE or a FUNCTION in the Query window.

    Tell me two things here ;
    1.) Is it really possible to defrag a MDF file (6 GB approx) that Windows 2003 Server OS failed to Defrag after 3 attempts, from within the Mgt.Studio by the way of a T-SQL Script … ??

    2.) If YES, How … ?? Do we use a Function or a Stored Procedure … ??

    Any guidance on this will be appreciated.

    Thanks & Regards,

    Aashish. Vaghela

    Like

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s