Consolidation by definition is the process of combining multiple SQL Server Databases & Servers running on different machines (could be geographically separated) onto a smaller number of more powerful machines in a central location. However in my opinion regarding SQL, its a process of getting organized, spending for what you need or use, and [...]
Archive for the ‘SQL Dev’ Category
SQL Server Consolidation & Virtualization Practice..
Posted: 22nd December 2010 by Deepak in SQL BI/DW/SSRS, SQL DBA, SQL Dev, UncategorizedTags: DBA, hyper-v, license, sql, sql consolidation, sql cost cutting, sql p2v, upgrade, virtual server, virtualization, vmware
0
Scripts to prepare SQL Server Inventory
Posted: 21st December 2010 by Deepak in Scripts, SQL DBA, SQL Dev, UncategorizedTags: audit, authentication, collation, configuration, installation, license, MAP, page file, properties, service account, sql inventory
You never know, when you may need to rebuild a SQL sever with exact properties and configurations. Although there are dozen of 3rd party tools and software available in market to prepare enterprise level SQL Server inventory hosted in your environment like Microsoft Assessment and Planning (MAP), but keeping your own DBA script handy is [...]
Setup a low disk space alert for SQL Server drives
Posted: 21st December 2010 by Deepak in Scripts, SQL DBA, SQL Dev, UncategorizedTags: disk alert, disk space, low disk space, space, sp_OACreate, sp_OADestroy, sql drives
This is the pretty easy and clean script that you may use to check periodically your database server drive space. You can create a job to run on hourly basis to execute this code, along with a database mail code to send you alert if any of drive has less than 15% or 20% threshold [...]
SQL 2011 – Denali CTP1
Posted: 30th November 2010 by Deepak in SQL DBA, SQL DevTags: ctp1, denali, hadr, sql 2011
Cheers group, we got SQL 2011 to test, learn and experience new things in SQL once again. I can’t wait to download and install it. Share your experiences! Here are few quick links to begin with, that you may want to check.. Microsoft(r) SQL Server(r) code-named ‘Denali’ – Community Technology Preview 1 (CTP1) Download Link [...]
Get Notification as soon as SQL Services are restarted
Posted: 17th September 2010 by Deepak in Scripts, SQL DBA, SQL DevTags: alarm, DBA, email, notification, restart, sql, sql notification, sql restarted, sql service restart, sqldba
Being production DBA and responsible for a dozen to 100+ SQL Servers running in your organization or datacenter, Sometimes, you must be wondering that how you can make sure you are fully aware what is going when you are not at work. There is an easy way to stay in touch with your SQL Server(s), [...]
Script to find used and free space in Database files
Posted: 2nd August 2010 by Deepak in Scripts, SQL BI/DW/SSRS, SQL DBA, SQL Dev, UncategorizedTags: database, db size, dbcc, dbcc showfilestats, dbcc sqlperf, disk, logspace, shrink, shrinkfile, space, sql server
In an Enterprise world, you may be responsible to monitor 1000+ databases hosted on hundreds of SQL Server instances. On a lazy afternoon, suddenly low disk space alarm hit your inbox. What will you do, storage can not be added or expended on the fly. Here is the tested script to find used and free [...]
How long does a SP stay in the cache?
Posted: 14th April 2010 by Deepak in Scripts, SQL BI/DW/SSRS, SQL DBA, SQL Dev, UncategorizedTags: administrator, buffer, cache, checkpoint, DBA, freeproccache, lazywriter, memory, memorystatus, sp, sqlperf, stored procedure
As a SQL Database Administrator, developer, designer you must be eager to know how long does a stored procedure execution plan stay in the cache? On what basis and parameters Microsoft SQL Server decide age of an execution plan to reside in cache? The quick answer is, it is based on the cost factor [...]
List of Undocumented DBCC command..
Posted: 10th March 2010 by Deepak in Scripts, SQL DBA, SQL Dev, UncategorizedTags: buffer, cachestats, checkalloc, checkdb, DBA, dbcc, dbcc page, shrinkfile, sql, sqldba, sqlperf, update, useplan
List of Undocumented DBCC command.. DBCC activecursors [(spid)] DBCC addextendedproc (function_name, dll_name) DBCC addinstance (objectname, instancename) DBCC adduserobject (name) DBCC auditevent (eventclass, eventsubclass, success, loginname, rolename, dbusername, loginid) DBCC autopilot (typeid, dbid, tabid, indid, pages [,flag]) DBCC balancefactor (variance_percent) DBCC bufcount [(number_of_buffers)] DBCC buffer ( {‘dbname’ | dbid} [, objid [, number [, printopt={0|1|2} ][, [...]
