Fusion-io MSSQL Server IOBottleneck Scripts

Fusion-io MS SQL Server Scripts

How to run:
  1. Download and save the script on your server.
  2. Open SQL Server Management Studio
  3. Open the Script by pressing CTRL + O in a query window
    1. a. If you want to capture system states since the SQL Server service started, then just execute the script by hitting F5 key.
    2. b. If you want to capture system states for a certain time period from the current moment onwards, then do the following:
      1. i. Comment out line 19. ( --SET @WaitDelay = NULL )
      2. ii. Specify the time period for which you want to capture data on line 18. ( SET @WaitDelay ='00:00:05.000'--This will collect data for 5 seconds. )
  4. Observe the data in the results window at the bottom of the screen.
Disclaimer:
  • Copyright 2013 Fusion-io, Inc.
  • This program is free software; you can redistribute it and/or modify it under the terms of the GNU General Public License version 2 as published by the Free Software Foundation.
  • This program is distributed in the hope that it will be useful, but WITHOUT ANY WARRANTY; without even the implied warranty of MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the GNU General Public License v2 for more details.
  • A copy of the GNU General Public License v2 can be found at: http://www.gnu.org/licenses/old- licenses/gpl-2.0.html
  • You should have received a copy of the GNU General Public License along with this program; if not, write to the Free Software Foundation, Inc., 59 Temple Place, Suite 330, Boston, MA 02111-1307 USA.
  • Although, this script is non-invasive, please run it at your own risk.

Last edited Jun 24, 2013 at 10:37 PM by fioappgroup, version 2

Comments

No comments yet.