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 (https://blog.sqlauthority.com)

Best Practices, Database, SQL Index, SQL Scripts, SQL Training
Previous Post
SQLAuthority News – Fathers and Daughters
Next Post
SQL SERVER – Soft Delete – IsDelete Column – Your Opinion

Related Posts

4 Comments. Leave new

  • 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?

    • 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,

  • Ian,

    I will be interested in reading your book.

    Kind Regards,

  • Aashish Vaghela
    September 14, 2010 3:47 am

    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


Leave a ReplyCancel reply

Exit mobile version