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