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 BI/DW/SSRS’ 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
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 [...]
