SQL Server 2005/ 2008 Performance/Maintenance Scripts Start Price USD 610.00 Current Price USD 610.00 Time Left - Bid Count 0 Buy It Now Price - Reserve Price - Start Time Tuesday, November 25, 2008 End Time Tuesday, December 02, 2008 Location Henderson, Nevada See more about 'SQL Server 2005/ 2008 Performance/Maintenance Scripts' Description Auction is for the scripts defined below written by a SQL Server DBA with experience in 6+ TB environments, 12 years of experience in enterprise environments, and Microsoft Certified MCITP: Database Developer. Purchase also entitled you to future enhancements free of charge...License requirement will be...You can obtain the license to modify/use the code for your own personal use and would not be allowed to claim ownership of the code or to redistribute it for any purpose whatsoever. The code is licensed per individual or per company not both. So if you purchase it for yourself, you can't use it for the companies you work for without paying for a license for each company. The scripts would be licensed for your use only, do not redistribute, publish, resell, or otherwise provide the scripts to others without my express written consent.ScriptsBetter_SP_Who.sql - An improved/customized version of SP_who2 that displays what proc is being ran. Waits being experienced, wait times, and various other information.On each database run, you will want to replace "master." in the script to be whatever database you're trying to watch. This will provide you with detailed locking information on that given database. ColumnListing_CommaDelimited.txt - Gives you a comma-delimited list of the columns in a given table width='100%'. It's great for quickly building insert/select statements.IO_LoadGenerator.sql - replace the "accounting" database with your database and it will generate IO that can be used for load testing on the disks.KILLSPIDS.sql - Kills all non-system spids in a database at a time, effectively kicking users out.ListAllDBFiles.sql - Lists all files currently being used by the SQL Server and their paths. Useful when you have many database files littered around and you're not sure what files are used and which were from databases taken offline. Also useful to verify path information on databases.ResetDBOwner.sql - All database should be owned by sa to eliminate problems of a database owner being deleted. This script resets all database owners in a given server to sa.S2K_ExecuteRights.sql - In SQL Server 2000, there is no way to global set execute rights to a given login. This script loops over the objects in the database and grants execute rights.S2K_Reindex.sql - SQL Server 2000 style reindexing.Search_Columns_or_Procs.txt - Searches tables for a given column name or procs for a given text string. Useful when you want to find all columns that contain a key like employeeID that might need to have the size changed or want to find a proc that operations on employeeid.SQL2K5 SID Script.sql - Reassociated orphaned database users to server logins on SQL Server 2000/2005/2008. Ignores AD logins since they are automatically mapped.SQLServer2005_blocking.txt - If a transaction is blocking another transaction, determine the cause. A transaction must be open, will not work with statements that do not open a transaction.SQLServer2005_FragmentationIdentification.txt - Returns index fragmentation on SQL Server 2005+SQLServer2005_FragReindexing.txt - Reindexes any database it's sitting on with the parameters set in the top. It's smart and will set the fill-factors' of identity columns to 100%, since they are every increasing and that will maximize IO usage (which even Microsoft's reindex script does do).Future enhancement coming - Auto detection of datetime columns.SQLServer_Recompile.sql - Sets all procs on the current database to be compiled on the next run so they can pick up new execution plans.Maintenance DB (Maintenance_DB.zip) - ProcsThe maintenance DB is basically a custom database that sits on any SQL Server box, jobs are then scheduled to run the following procs against all the other databases on the server providing maintenance activities. This way each job does not contain any code, so any maintenance proc fixes/modifications/improvements only occur in one location and use dynamic SQL. Sample job: Sample_MaintenanceReindexingJob.sql.Proc_MTRecompileObjects - recompiles all procs in a given database.Proc_MTReindex - Operates with any schema owner - Reindexes all tables within a given DB. You can set a wide variety of settings to control the load on the server. Please note that online reindexing is only available in enterprise edition of SQL Server. If the database is in full-recovery, you will want to set the "@bSwitchToBulkLog" flag on otherwise your transaction log may fill up. Setting this flag on switches the database into bulk-logged mode so most of the reindexing activities are not logged till the next transaction log backup. If it fails for some reason it will switch the database back to full recovery as part of it's error handling. If the database mode is simple and this flag is turned on, it will be ignored.Proc_MTUpdateStats - Operates with any schema owner - Updates the statistics on a system with a variety of parameters, sampling rates, delays, etc. Basically allows for more detailed statistics. CAUTION: this will update stats on all statistics, so it is very IO intensive and generates more IO load then sp_updatestats, since sp_updatestats only updates stats that have been modified. So use this only when detailed stats are needed or to periodically gather very detailed stats.Future Enhancement after Microsoft fixes system views - Provide switch to allow only the updating of stats that are outdated. Place a Bid!