DBA WORLD

Wednesday, February 26, 2014

End of support - List of MSSQL

http://support.microsoft.com/lifecycle/search/?sort=PN&alpha=sql

Products Released	Lifecycle Start Date	Mainstream Support End Date	Extended Support End Date	Service Pack Support End Date	Notes
SQL Server 2000 64-bit Edition	11/30/2000	4/8/2008	4/9/2013	7/11/2002
SQL Server 2000 Desktop Engine	11/30/2000	4/8/2008	4/9/2013
SQL Server 2000 Desktop Engine Release A	1/29/2003	4/8/2008	4/9/2013
SQL Server 2000 Developer Edition	11/30/2000	4/8/2008	4/9/2013	7/11/2002
SQL Server 2000 Enterprise Edition	11/30/2000	4/8/2008	4/9/2013	7/11/2002
SQL Server 2000 Reporting Services Service Pack 1	9/22/2004	Not Applicable	Not Applicable	7/11/2006
SQL Server 2000 Reporting Services Service Pack 2	4/22/2005	Review Note	Review Note		Support ends 12 months after the next service pack releases or at the end of the product's support lifecycle, whichever comes first. For more information, please see the service pack policy at http://support.microsoft.com/lifecycle/#ServicePackSupport.
SQL Server 2000 Service Pack 1	6/12/2001	Not Applicable	Not Applicable	2/28/2002
SQL Server 2000 Service Pack 2	11/30/2001	Not Applicable	Not Applicable	4/7/2003
SQL Server 2000 Service Pack 3a	1/7/2003	Not Applicable	Not Applicable	7/10/2007
SQL Server 2000 Service Pack 4	5/6/2005	Review Note	Review Note		Support ends 12 months after the next service pack releases or at the end of the product's support lifecycle, whichever comes first. For more information, please see the service pack policy at http://support.microsoft.com/lifecycle/#ServicePackSupport.
SQL Server 2000 Standard Edition	11/30/2000	4/8/2008	4/9/2013	7/11/2002
SQL Server 2000 Windows CE Edition 2.0	12/16/2002	1/8/2008	1/8/2013
SQL Server 2000 Workgroup Edition	6/1/2005	4/8/2008	4/9/2013
SQL Server 2005 Compact Edition	2/19/2007	4/12/2011	4/12/2016	7/10/2007
SQL Server 2005 Developer Edition	1/14/2006	4/12/2011	4/12/2016	7/10/2007
SQL Server 2005 Enterprise Edition	1/14/2006	4/12/2011	4/12/2016	7/10/2007
SQL Server 2005 Enterprise Edition for Itanium-based Systems	1/14/2006	4/12/2011	4/12/2016	7/10/2007
SQL Server 2005 Enterprise X64 Edition	1/14/2006	4/12/2011	4/12/2016	7/10/2007
SQL Server 2005 Express Edition	6/1/2006	4/12/2011	4/12/2016	7/10/2007
SQL Server 2005 Express Edition with Advanced Services	7/16/2006	4/12/2011	4/12/2016	7/10/2007
SQL Server 2005 Service Pack 1	4/18/2006	Not Applicable	Not Applicable	4/8/2008
SQL Server 2005 Service Pack 2	2/19/2007	Not Applicable	Not Applicable	1/12/2010
SQL Server 2005 Service Pack 3	12/15/2008	Not Applicable	Not Applicable	1/10/2012
SQL Server 2005 Service Pack 4	12/13/2010	Review Note	Review Note		Support ends 12 months after the next service pack releases or at the end of the product's support lifecycle, whichever comes first. For more information, please see the service pack policy at http://support.microsoft.com/lifecycle/#ServicePackSupport.
SQL Server 2005 Standard Edition	1/14/2006	4/12/2011	4/12/2016	7/10/2007
SQL Server 2005 Standard Edition for Itanium-based Systems	1/14/2006	4/12/2011	4/12/2016	7/10/2007
SQL Server 2005 Standard X64 Edition	1/14/2006	4/12/2011	4/12/2016	7/10/2007
SQL Server 2005 Workgroup Edition	1/14/2006	4/12/2011	4/12/2016	7/10/2007
SQL Server 2008 Developer	11/6/2008	7/8/2014	7/9/2019	4/13/2010
SQL Server 2008 Enterprise	11/7/2008	7/8/2014	7/9/2019	4/13/2010
SQL Server 2008 Express	11/11/2008	7/8/2014	7/9/2019	4/13/2010
SQL Server 2008 Express with Advanced Services	11/22/2008	7/8/2014	7/9/2019	4/13/2010
SQL Server 2008 R2 Datacenter	7/20/2010	7/8/2014	7/9/2019	7/10/2012
SQL Server 2008 R2 Developer	7/20/2010	7/8/2014	7/9/2019	7/10/2012
SQL Server 2008 R2 Enterprise	7/20/2010	7/8/2014	7/9/2019	7/10/2012
SQL Server 2008 R2 Express	7/20/2010	7/8/2014	7/9/2019	7/10/2012
SQL Server 2008 R2 Express with Advanced Services	7/20/2010	7/8/2014	7/9/2019	7/10/2012
SQL Server 2008 R2 Parallel Data Warehouse	11/9/2010	7/8/2014	7/9/2019		Hardware products will receive 5 years of support following Microsoft’s end of sales date for the Major Product version. Minor Product releases follow the Support Lifecycle of their respective Major Product versions.
SQL Server 2008 R2 Service Pack 1	7/12/2011	Not Applicable	Not Applicable	10/8/2013
SQL Server 2008 R2 Service Pack 2	7/26/2012	Review Note	Review Note		Support ends 12 months after the next service pack releases or at the end of the product's support lifecycle, whichever comes first. For more information, please see the service pack policy at http://support.microsoft.com/lifecycle/#ServicePackSupport.
SQL Server 2008 R2 Standard	7/20/2010	7/8/2014	7/9/2019	7/10/2012
SQL Server 2008 R2 Standard Edition for Small Business	7/20/2010	7/8/2014	7/9/2019	7/10/2012
SQL Server 2008 R2 Web	7/20/2010	7/8/2014	7/9/2019	7/10/2012
SQL Server 2008 R2 Workgroup	7/20/2010	7/8/2014	7/9/2019	7/10/2012
SQL Server 2008 Service Pack 1	3/31/2009	Not Applicable	Not Applicable	10/11/2011
SQL Server 2008 Service Pack 2	9/24/2010	Not Applicable	Not Applicable	10/9/2012
SQL Server 2008 Service Pack 3	10/6/2011	Review Note	Review Note		Support ends 12 months after the next service pack releases or at the end of the product's support lifecycle, whichever comes first. For more information, please see the service pack policy at http://support.microsoft.com/lifecycle/#ServicePackSupport.
SQL Server 2008 Standard	11/6/2008	7/8/2014	7/9/2019	4/13/2010
SQL Server 2008 Standard Edition for Small Business	11/6/2008	7/8/2014	7/9/2019	4/13/2010
SQL Server 2008 Web	11/6/2008	7/8/2014	7/9/2019	4/13/2010
SQL Server 2008 Workgroup	11/6/2008	7/8/2014	7/9/2019	4/13/2010
SQL Server 2012 Business Intelligence	5/20/2012	7/11/2017	7/12/2022	1/14/2014
SQL Server 2012 Developer	5/20/2012	7/11/2017	7/12/2022	1/14/2014
SQL Server 2012 Enterprise	5/20/2012	7/11/2017	7/12/2022	1/14/2014
SQL Server 2012 Enterprise Core	5/20/2012	7/11/2017	7/12/2022
SQL Server 2012 Express	5/20/2012	7/11/2017	7/12/2022	1/14/2014
SQL Server 2012 Parallel Data Warehouse	7/12/2013	10/9/2018	Review Note		SQL 2012 PDW appliance hardware and the server software configured and running on the appliance hardware shall receive five years of support from General Availability of SQL Server Parallel Data Warehouse 2012.
SQL Server 2012 Service Pack 1	11/7/2012	Review Note	Review Note		Support ends 12 months after the next service pack releases or at the end of the product's support lifecycle, whichever comes first. For more information, please see the service pack policy at http://support.microsoft.com/lifecycle/#ServicePackSupport.
SQL Server 2012 Standard	5/20/2012	7/11/2017	7/12/2022	1/14/2014
SQL Server 2012 Web	5/20/2012	7/11/2017	7/12/2022	1/14/2014
SQL Server 4.2 for OS/2	Not Available	7/1/1999	Not Applicable
SQL Server 6.0 Standard Edition	Not Available	3/31/1999	Not Applicable
SQL Server 6.5 Enterprise Edition	3/1/1998	3/31/2004	Not Applicable
SQL Server 6.5 Service Pack 1	12/31/1998	Not Applicable	Not Applicable	1/1/2002
SQL Server 6.5 Service Pack 2	9/15/2000	Not Applicable	Not Applicable
SQL Server 6.5 Service Pack 3	1/15/2000	Not Applicable	Not Applicable
SQL Server 6.5 Service Pack 4	Not Available	Not Applicable	Not Applicable	3/24/1999
SQL Server 6.5 Service Pack 5a	12/24/1998	Not Applicable	Not Applicable	3/31/2004
SQL Server 6.5 Standard Edition	6/30/1996	1/1/2002	Not Applicable
SQL Server 7.0 Enterprise Edition	3/1/1999	12/31/2005	1/11/2011
SQL Server 7.0 Service Pack 1	5/25/1999	Not Applicable	Not Applicable	3/31/2004
SQL Server 7.0 Service Pack 2	3/20/2000	Not Applicable	Not Applicable
SQL Server 7.0 Service Pack 3	Not Available	Not Applicable	Not Applicable	7/26/2002
SQL Server 7.0 Service Pack 4	4/26/2002	Review Note	Review Note		Support ends 12 months after the next service pack releases or at the end of the product's support lifecycle, whichever comes first. For more information, please see the service pack policy at http://support.microsoft.com/lifecycle/#ServicePackSupport.
SQL Server 7.0 Standard Edition	3/1/1999	12/31/2005	1/11/2011
SQL Server Compact 3.5	2/19/2008	4/9/2013	4/10/2018	10/13/2009
SQL Server Compact 3.5 Service Pack 1 for Windows Mobile	8/11/2008	Not Applicable	Not Applicable	7/12/2011
SQL Server Compact 3.5 Service Pack 2	6/29/2010	Review Note	Review Note		Support ends 12 months after the next service pack releases or at the end of the product's support lifecycle, whichever comes first. For more information, please see the service pack policy at http://support.microsoft.com/lifecycle/#ServicePackSupport.
SQL Server Compact 4.0	4/13/2011	7/12/2016	7/13/2021
SQL Server Notification Services 2.0 Enterprise Edition	11/26/2002	1/8/2008	1/8/2013
SQL Server Notification Services 2.0 Standard Edition	11/26/2002	1/8/2008	1/8/2013

Monday, November 15, 2010

Wednesday, March 31, 2010

INDEX USAGE ANALYSIS REPORT

How to generate report for Index Physical statistics

Here is an interesting information about how to generate report for Index Usage

Check the below link and enjoy the usage of indexes and recommendations using one click report!!

http://blog.sqlauthority.com/2010/03/26/sql-server-generate-report-for-index-physical-statistics-ssms/

SQL Server 2008 - New Features

New Features in MS SQL Server 2008 - Database Administrators

The below link provides us an insight about the new features in MS SQL Server 2008 for Database Administrators.

Have a look at this link and enjoy the new features!

http://sqlcat.com/top10lists/archive/2009/01/30/top-10-sql-server-2008-features-for-the-database-administrator-dba.aspx

DBCC Commands

How to Check the List of DBCC Commands using SQL Server

Get a list of all the DBCC commands both documented and undocumented.

Solution: Turn on trace 2520 and use DBCC HELP ('?') to get a list of all the commands.

The script:

dbcc traceon(2520)
dbcc help ('?')
GO

Shows the list of DBCC commands. then

DBCC HELP()

Shows the syntax of an individual co

If you run DBCC HELP on all the commands you end up with this list:

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} ]
[, dirty | io | kept | rlock | ioerr | hashed ]]])

DBCC bytes ( startaddress, length )

DBCC cachestats

DBCC callfulltext

DBCC checkalloc [('database_name'[, NOINDEX | REPAIR])]
[WITH NO_INFOMSGS[, ALL_ERRORMSGS][, ESTIMATEONLY]]

DBCC checkcatalog [('database_name')] [WITH NO_INFOMSGS]

DBCC checkconstraints [( 'tab_name' | tab_id | 'constraint_name' | constraint_id )]
[WITH ALL_CONSTRAINTS | ALL_ERRORMSGS]

DBCC checkdb [('database_name'[, NOINDEX | REPAIR])]
[WITH NO_INFOMSGS[, ALL_ERRORMSGS]
[, PHYSICAL_ONLY][, ESTIMATEONLY][,DBCC TABLOCK]

DBCC checkdbts (dbid, newTimestamp)]

DBCC checkfilegroup [( [ {'filegroup_name' | filegroup_id} ]
[, NOINDEX] )] [WITH NO_INFOMSGS
[, ALL_ERRORMSGS][, PHYSICAL_ONLY][, ESTIMATEONLY][, TABLOCK]]

DBCC checkident ('table_name'[, { NORESEED | {RESEED [, new_reseed_value] } } ] )

DBCC checkprimaryfile ( {'FileName'} [, opt={0|1|2|3} ])

DBCC checktable ('table_name'[, {NOINDEX | index_id | REPAIR}])
[WITH NO_INFOMSGS[, ALL_ERRORMSGS]
[, PHYSICAL_ONLY][, ESTIMATEONLY][, TABLOCK]]

DBCC cleantable ('database_name'|database_id, 'table_name'|table_id,[batch_size])

DBCC cacheprofile [( {actionid} [, bucketid])

DBCC clearspacecaches ('database_name'|database_id,
'table_name'|table_id, 'index_name'|index_id)

DBCC collectstats (on | off)

DBCC concurrencyviolation (reset | display | startlog | stoplog)

DBCC config

DBCC cursorstats ([spid [,'clear']])

DBCC dbinfo [('dbname')]

DBCC dbrecover (dbname [, IgnoreErrors])

DBCC dbreindex ('table_name' [, index_name [, fillfactor ]]) [WITH NO_INFOMSGS]

DBCC dbreindexall (db_name/db_id, type_bitmap)

DBCC dbrepair ('dbname', DROPDB [, NOINIT])

DBCC dbtable [({'dbname' | dbid})]

DBCC debugbreak

DBCC deleteinstance (objectname, instancename)

DBCC des [( {'dbname' | dbid} [, {'objname' | objid} ])]

DBCC detachdb [( 'dbname' )]

DBCC dropcleanbuffers

DBCC dropextendedproc (function_name)

DBCC dropuserobject ('object_name')

DBCC dumptrigger ({'BREAK', {0 | 1}} | 'DISPLAY' | {'SET', exception_number}
| {'CLEAR', exception_number})

DBCC errorlog

DBCC extentinfo [({'database_name'| dbid | 0}
[,{'table_name' | table_id} [, {'index_name' | index_id | -1}]])]

DBCC fileheader [( {'dbname' | dbid} [, fileid])

DBCC fixallocation [({'ADD' | 'REMOVE'},
{'PAGE' | 'SINGLEPAGE' | 'EXTENT' | 'MIXEDEXTENT'}
, filenum, pagenum [, objectid, indid])

DBCC flush ('data' | 'log', dbid)

DBCC flushprocindb (database)

DBCC free dll_name (FREE)

DBCC freeproccache

dbcc freeze_io (db)

dbcc getvalue (name)

dbcc icecapquery ('dbname', stored_proc_name
[, #_times_to_icecap (-1 infinite, 0 turns off)])
Use 'dbcc icecapquery (printlist)' to see list of SP's to profile.
Use 'dbcc icecapquery (icecapall)' to profile all SP's.

dbcc incrementinstance (objectname, countername, instancename, value)

dbcc ind ( { 'dbname' | dbid }, { 'objname' | objid }, { indid | 0 | -1 | -2 } )

DBCC indexdefrag ({dbid | dbname | 0}, {tableid | tablename}, {indid |indname})

DBCC inputbuffer (spid)

DBCC invalidate_textptr (textptr)

DBCC invalidate_textptr_objid (objid)

DBCC iotrace ( { 'dbname' | dbid | 0 | -1 }
, { fileid | 0 }, bufsize, [ { numIOs | -1 }
[, { timeout (sec) | -1 } [, printopt={ 0 | 1 }]]] )

DBCC latch ( address [, 'owners'] [, 'stackdumps'])

DBCC lock ([{'DUMPTABLE' | 'DUMPSTATS' | 'RESETSTATS' | 'HASH'}] |
[{'STALLREPORTTHESHOLD', stallthreshold}])

DBCC lockobjectschema ('object_name')

DBCC log ([dbid[,{0|1|2|3|4}[,['lsn','[0x]x:y:z']|['numrecs',num]|['xdesid','x:y']
|['extent','x:y']|['pageid','x:y']|['objid',{x,'y'}]|['logrecs',
{'lop'|op}...]|['output',x,['filename','x']]...]]])

DBCC loginfo [({'database_name' | dbid})]

DBCC matview ({'PERSIST' | 'ENDPERSIST' | 'FREE' | 'USE' | 'ENDUSE'})

DBCC memobjlist [(memory object)]

DBCC memorymap

DBCC memorystatus

DBCC memospy

DBCC memusage ([IDS | NAMES], [Number of rows to output])

DBCC monitorevents ('sink' [, 'filter-expression'])

DBCC newalloc - please use checkalloc instead

DBCC no_textptr (table_id , max_inline)

DBCC opentran [({'dbname'| dbid})] [WITH TABLERESULTS[,NO_INFOMSGS]]

DBCC outputbuffer (spid)

DBCC page ( {'dbname' | dbid}, filenum, pagenum
[, printopt={0|1|2|3} ][, cache={0|1} ])

DBCC perflog

DBCC perfmon

DBCC pglinkage (dbid, startfile, startpg, number, printopt={0|1|2}
, targetfile, targetpg, order={1|0})

DBCC pintable (database_id, table_id)

DBCC procbuf [({'dbname' | dbid}[, {'objname' | objid}
[, nbufs[, printopt = { 0 | 1 } ]]] )]

DBCC proccache

DBCC prtipage (dbid, objid, indexid [, [{{level, 0}
| {filenum, pagenum}}] [,printopt]])

DBCC pss [(uid[, spid[, printopt = { 1 | 0 }]] )]

DBCC readpage ({ dbid, 'dbname' }, fileid, pageid
, formatstr [, printopt = { 0 | 1} ])

DBCC rebuild_log (dbname [, filename])

DBCC renamecolumn (object_name, old_name, new_name)

DBCC resource

DBCC row_lock (dbid, tableid, set) - Not Needed

DBCC ruleoff ({ rulenum | rulestring } [, { rulenum | rulestring } ]+)

DBCC ruleon ( rulenum | rulestring } [, { rulenum | rulestring } ]+)

DBCC setcpuweight (weight)

DBCC setinstance (objectname, countername, instancename, value)

DBCC setioweight (weight)

DBCC show_statistics ('table_name', 'target_name')

DBCC showcontig (table_id | table_name [, index_id | index_name]
[WITH FAST, ALL_INDEXES, TABLERESULTS [,ALL_LEVELS]])

DBCC showdbaffinity

DBCC showfilestats [(file_num)]

DBCC showoffrules

DBCC showonrules

DBCC showtableaffinity (table)

DBCC showtext ('dbname', {textpointer | {fileid, pageid, slotid[,option]}})

DBCC showweights

DBCC shrinkdatabase ({dbid | 'dbname'}, [freespace_percentage
[, {NOTRUNCATE | TRUNCATEONLY}]])

DBCC shrinkfile ({fileid | 'filename'}, [compress_size
[, {NOTRUNCATE | TRUNCATEONLY | EMPTYFILE}]])

DBCC sqlmgrstats

DBCC sqlperf (LOGSPACE)({IOSTATS | LRUSTATS | NETSTATS | RASTATS [, CLEAR]}
| {THREADS} | {LOGSPACE})

DBCC stackdump [( {uid[, spid[, ecid]} | {threadId, 'THREADID'}] )]

DBCC tab ( dbid, objid )

DBCC tape_control {'query' | 'release'}[,('\\.\tape')]

DBCC tec [( uid[, spid[, ecid]] )]

DBCC textall [({'database_name'|database_id}[, 'FULL' | FAST] )]

DBCC textalloc ({'table_name'|table_id}[, 'FULL' | FAST])

DBCC thaw_io (db)

DBCC traceoff [( tracenum [, tracenum ... ] )]

DBCC traceon [( tracenum [, tracenum ... ] )]

DBCC tracestatus (trace# [, ...trace#])

DBCC unpintable (dbid, table_id)

DBCC updateusage ({'database_name'| 0} [, 'table_name' [, index_id]])
[WITH [NO_INFOMSGS] [,] COUNT_ROWS]

DBCC upgradedb (db) DBCC usagegovernor (command, value)

DBCC useplan [(number_of_plan)]

DBCC useroptions DBCC wakeup (spid)


DBCC writepage ({ dbid, 'dbname' }, fileid, pageid, offset, length, data)

DMV List

Here We Go.......................

The Complete List of DMV/DMF present in SQL Server 2005 and 2008.

DMV/DMF Name	2005	2008
dm_audit_actions		X
dm_audit_class_type_map		X
dm_broker_activated_tasks	X	X
dm_broker_connections	X	X
dm_broker_forwarded_messages	X	X
dm_broker_queue_monitors	X	X
dm_cdc_errors		X
dm_cdc_log_scan_sessions		X
dm_clr_appdomains	X	X
dm_clr_loaded_assemblies	X	X
dm_clr_properties	X	X
dm_clr_tasks	X	X
dm_cryptographic_provider_properties		X
dm_database_encryption_keys		X
dm_db_file_space_usage	X	X
dm_db_index_usage_stats	X	X
dm_db_mirroring_auto_page_repair		X
dm_db_mirroring_connections	X	X
dm_db_mirroring_past_actions		X
dm_db_missing_index_details	X	X
dm_db_missing_index_group_stats	X	X
dm_db_missing_index_groups	X	X
dm_db_partition_stats	X	X
dm_db_persisted_sku_features		X
dm_db_script_level		X
dm_db_session_space_usage	X	X
dm_db_task_space_usage	X	X
dm_exec_background_job_queue	X	X
dm_exec_background_job_queue_stats	X	X
dm_exec_cached_plans	X	X
dm_exec_connections	X	X
dm_exec_procedure_stats		X
dm_exec_query_memory_grants	X	X
dm_exec_query_optimizer_info	X	X
dm_exec_query_resource_semaphores	X	X
dm_exec_query_stats	X	X
dm_exec_query_transformation_stats	X	X
dm_exec_requests	X	X
dm_exec_sessions	X	X
dm_exec_trigger_stats		X
dm_filestream_file_io_handles		X
dm_filestream_file_io_requests		X
dm_fts_active_catalogs	X	X
dm_fts_fdhosts		X
dm_fts_index_population	X	X
dm_fts_memory_buffers	X	X
dm_fts_memory_pools	X	X
dm_fts_outstanding_batches		X
dm_fts_population_ranges	X	X
dm_io_backup_tapes	X	X
dm_io_cluster_shared_drives	X	X
dm_io_pending_io_requests	X	X
dm_os_buffer_descriptors	X	X
dm_os_child_instances	X	X
dm_os_cluster_nodes	X	X
dm_os_dispatcher_pools		X
dm_os_dispatchers		X
dm_os_hosts	X	X
dm_os_latch_stats	X	X
dm_os_loaded_modules	X	X
dm_os_memory_allocations	X	X
dm_os_memory_brokers		X
dm_os_memory_cache_clock_hands	X	X
dm_os_memory_cache_counters	X	X
dm_os_memory_cache_entries	X	X
dm_os_memory_cache_hash_tables	X	X
dm_os_memory_clerks	X	X
dm_os_memory_node_access_stats		X
dm_os_memory_nodes		X
dm_os_memory_objects	X	X
dm_os_memory_pools	X	X
dm_os_nodes		X
dm_os_performance_counters	X	X
dm_os_process_memory		X
dm_os_ring_buffers	X	X
dm_os_schedulers	X	X
dm_os_spinlock_stats		X
dm_os_stacks	X	X
dm_os_sublatches	X	X
dm_os_sys_info	X	X
dm_os_sys_memory		X
dm_os_tasks	X	X
dm_os_threads	X	X
dm_os_virtual_address_dump	X	X
dm_os_wait_stats	X	X
dm_os_waiting_tasks	X	X
dm_os_worker_local_storage	X	X
dm_os_workers	X	X
dm_qn_subscriptions	X	X
dm_repl_articles	X	X
dm_repl_schemas	X	X
dm_repl_tranhash	X	X
dm_repl_traninfo	X	X
dm_resource_governor_configuration		X
dm_resource_governor_resource_pools		X
dm_resource_governor_workload_groups		X
dm_server_audit_status		X
dm_tran_active_snapshot_database_transactions	X	X
dm_tran_active_transactions	X	X
dm_tran_commit_table		X
dm_tran_current_snapshot	X	X
dm_tran_current_transaction	X	X
dm_tran_database_transactions	X	X
dm_tran_locks	X	X
dm_tran_session_transactions	X	X
dm_tran_top_version_generators	X	X
dm_tran_transactions_snapshot	X	X
dm_tran_version_store	X	X
dm_xe_map_values		X
dm_xe_object_columns		X
dm_xe_objects		X
dm_xe_packages		X
dm_xe_session_event_actions		X
dm_xe_session_events		X
dm_xe_session_object_columns		X
dm_xe_session_targets		X
dm_xe_sessions		X

Friday, March 5, 2010

Over Time for DBA?

Interesting info about DBA.

http://www.sqlservercentral.com/blogs/aloha_dba/archive/2010/2/27/should-dbas-be-paid-overtime_3F00_.aspx