Fusion-io MS SQL Server 2012 IO Bottleneck Scripts

Rating: No reviews yet
Downloads: 103
Released: Jun 24, 2013
Updated: Jun 24, 2013 by fioappgroup
Dev status: Stable Help Icon

Recommended Download

Application ShowIOBottlenecksSQL2012
application, 261K, uploaded Jun 24, 2013 - 103 downloads

Release Notes

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.

Reviews for this release

No reviews yet for this release.