Blog Post

Events By Feature

,

sql_features_xeWithin the world of SQL Server there are a few things one can be certain of – things will change. This is true of the features in SQL Server. Additionally, Extended Events is constantly evolving which underscores this constant change.

With all of this change occurring within SQL Server, sometimes it is difficult to figure out how to troubleshoot or track issues that relate to new features. Within the need to figure out how to troubleshoot the new features, there is the need to understand what tools are out there to help troubleshoot.

It is no big secret that Profiler cannot help you trace any of the new features. To help perform the task of tracing events related to new features one must take advantage of the power of Extended Events. Even knowing that you can use XEvents, there is still a need to know what is related to the feature.

In this article, I will show how you can discover the events related to specific features. In addition, I will provide enough base information to help you perform other discovery type queries on your own as you continue your exploration of XEvents. In case you are a bit behind in your exploration of XEvents, I have the perfect solution for you – my series on the topic that is continually growing. You can explore the full list of articles in the series by visiting the table of contents – here.

Events and Features

More and more I am being asked how to track which events belong to which features. I have also been seeing more people ask for a way to list the new features supported by XEvents. Thankfully there is adequate information within the XEvent metadata to help retrieve this type of information. The downside is that there is a bit of homework that must be done across a few versions of SQL Server to help produce the desired information. I have done that work and pulled the information into the following query to help make it easier for anybody else wishing to dive in and compare features and events across versions of SQL Server.

DECLARE @ServerMajorVersion DECIMAL(4, 2)
SELECT @ServerMajorVersion = CONVERT(DECIMAL(4, 2), PARSENAME(dt.fqn, 4) + '.'
+ PARSENAME(dt.fqn, 3))
FROM ( SELECT CONVERT(VARCHAR(20), SERVERPROPERTY('ProductVersion'))
) dt ( fqn );
IF OBJECT_ID('tempdb.dbo.#XEVersions') IS NOT NULL
BEGIN
DROP TABLE #XEVersions;
END
CREATE TABLE #XEVersions
(VersionID INT IDENTITY(1,1)
, Product VARCHAR(32)
, ServerMajorVersion DECIMAL(4, 2) --INDEX CI_ServerMajorVer CLUSTERED
);
CREATE CLUSTERED INDEX CI_ServerMajorVer ON#XEVersions (VersionID);
INSERT INTO#XEVersions
( Product
, ServerMajorVersion
)
VALUES
( 'SQL Server 2008', 10.00)
,( 'SQL Server 2008R2', 10.50)
,( 'SQL Server 2012', 11.00)
,( 'SQL Server 2014', 12.00)
,( 'SQL Server 2016', 13.00);
IF OBJECT_ID('tempdb.dbo.#XECounts') IS NOT NULL
BEGIN
DROP TABLE #XECounts;
END
CREATE TABLE #XECounts
(
[Feature] [NVARCHAR](3072) NOT NULL
, [FeatureEventCount] [INT] NULL
, [SQLVersion] [DECIMAL](4, 2) NULL
);
INSERT INTO #XECounts
( [Feature], [FeatureEventCount], [SQLVersion] )
VALUES( N'_UnAssigned', 27, CAST(12.00 AS DECIMAL(4, 2)) )
, ( N'access_methods', 23, CAST(12.00 AS DECIMAL(4, 2)) )
, ( N'alwayson', 100, CAST(12.00 AS DECIMAL(4, 2)) )
, ( N'broker', 42, CAST(12.00 AS DECIMAL(4, 2)) )
, ( N'cdc_logscan', 2, CAST(12.00 AS DECIMAL(4, 2)) )
, ( N'change_tracking', 2, CAST(12.00 AS DECIMAL(4, 2)) )
, ( N'checkpoint', 17, CAST(12.00 AS DECIMAL(4, 2)) )
, ( N'ckpt_trace', 37, CAST(12.00 AS DECIMAL(4, 2)) )
, ( N'ckptworker_trace', 21, CAST(12.00 AS DECIMAL(4, 2)) )
, ( N'clr', 3, CAST(12.00 AS DECIMAL(4, 2)) )
, ( N'cursor', 18, CAST(12.00 AS DECIMAL(4, 2)) )
, ( N'database', 42, CAST(12.00 AS DECIMAL(4, 2)) )
, ( N'deadlock_monitor', 7, CAST(12.00 AS DECIMAL(4, 2)) )
, ( N'deploy', 14, CAST(12.00 AS DECIMAL(4, 2)) )
, ( N'errors', 20, CAST(12.00 AS DECIMAL(4, 2)) )
, ( N'exception', 4, CAST(12.00 AS DECIMAL(4, 2)) )
, ( N'execution', 115, CAST(12.00 AS DECIMAL(4, 2)) )
, ( N'filetable', 13, CAST(12.00 AS DECIMAL(4, 2)) )
, ( N'fulltext', 8, CAST(12.00 AS DECIMAL(4, 2)) )
, ( N'garbage_collection', 1, CAST(12.00 AS DECIMAL(4, 2)) )
, ( N'gc', 4, CAST(12.00 AS DECIMAL(4, 2)) )
, ( N'hadr', 1, CAST(12.00 AS DECIMAL(4, 2)) )
, ( N'index', 9, CAST(12.00 AS DECIMAL(4, 2)) )
, ( N'init', 1, CAST(12.00 AS DECIMAL(4, 2)) )
, ( N'io', 33, CAST(12.00 AS DECIMAL(4, 2)) )
, ( N'latch', 6, CAST(12.00 AS DECIMAL(4, 2)) )
, ( N'lock', 15, CAST(12.00 AS DECIMAL(4, 2)) )
, ( N'memory', 35, CAST(12.00 AS DECIMAL(4, 2)) )
, ( N'merge_trace', 23, CAST(12.00 AS DECIMAL(4, 2)) )
, ( N'oledb', 5, CAST(12.00 AS DECIMAL(4, 2)) )
, ( N'optimization', 2, CAST(12.00 AS DECIMAL(4, 2)) )
, ( N'process', 12, CAST(12.00 AS DECIMAL(4, 2)) )
, ( N'query_store', 31, CAST(12.00 AS DECIMAL(4, 2)) )
, ( N'replication', 8, CAST(12.00 AS DECIMAL(4, 2)) )
, ( N'scheduling', 26, CAST(12.00 AS DECIMAL(4, 2)) )
, ( N'security', 3, CAST(12.00 AS DECIMAL(4, 2)) )
, ( N'server', 19, CAST(12.00 AS DECIMAL(4, 2)) )
, ( N'session', 17, CAST(12.00 AS DECIMAL(4, 2)) )
, ( N'storage_management', 13, CAST(12.00 AS DECIMAL(4, 2)) )
, ( N'synchronization', 2, CAST(12.00 AS DECIMAL(4, 2)) )
, ( N'task', 2, CAST(12.00 AS DECIMAL(4, 2)) )
, ( N'transaction', 10, CAST(12.00 AS DECIMAL(4, 2)) )
, ( N'transactions', 48, CAST(12.00 AS DECIMAL(4, 2)) )
, ( N'transmitter', 9, CAST(12.00 AS DECIMAL(4, 2)) )
, ( N'transport', 9, CAST(12.00 AS DECIMAL(4, 2)) )
, ( N'ucs', 8, CAST(12.00 AS DECIMAL(4, 2)) )
, ( N'warnings', 7, CAST(12.00 AS DECIMAL(4, 2)) )
, ( N'xtp', 15, CAST(12.00 AS DECIMAL(4, 2)) )
, ( N'_UnAssigned', 9, CAST(10.50 AS DECIMAL(4, 2)) )
, ( N'access_methods', 6, CAST(10.50 AS DECIMAL(4, 2)) )
, ( N'broker', 73, CAST(10.50 AS DECIMAL(4, 2)) )
, ( N'cdc_logscan', 2, CAST(10.50 AS DECIMAL(4, 2)) )
, ( N'change_tracking', 1, CAST(10.50 AS DECIMAL(4, 2)) )
, ( N'clr', 2, CAST(10.50 AS DECIMAL(4, 2)) )
, ( N'cursor', 11, CAST(10.50 AS DECIMAL(4, 2)) )
, ( N'database', 21, CAST(10.50 AS DECIMAL(4, 2)) )
, ( N'deadlock_monitor', 6, CAST(10.50 AS DECIMAL(4, 2)) )
, ( N'errors', 5, CAST(10.50 AS DECIMAL(4, 2)) )
, ( N'exception', 3, CAST(10.50 AS DECIMAL(4, 2)) )
, ( N'execution', 14, CAST(10.50 AS DECIMAL(4, 2)) )
, ( N'io', 20, CAST(10.50 AS DECIMAL(4, 2)) )
, ( N'latch', 5, CAST(10.50 AS DECIMAL(4, 2)) )
, ( N'lock', 6, CAST(10.50 AS DECIMAL(4, 2)) )
, ( N'memory', 12, CAST(10.50 AS DECIMAL(4, 2)) )
, ( N'process', 12, CAST(10.50 AS DECIMAL(4, 2)) )
, ( N'replication', 7, CAST(10.50 AS DECIMAL(4, 2)) )
, ( N'scheduling', 21, CAST(10.50 AS DECIMAL(4, 2)) )
, ( N'server', 21, CAST(10.50 AS DECIMAL(4, 2)) )
, ( N'synchronization', 1, CAST(10.50 AS DECIMAL(4, 2)) )
, ( N'transactions', 6, CAST(10.50 AS DECIMAL(4, 2)) )
, ( N'_UnAssigned', 83, CAST(13.00 AS DECIMAL(4, 2)) )
, ( N'access_methods', 19, CAST(13.00 AS DECIMAL(4, 2)) )
, ( N'alwayson', 117, CAST(13.00 AS DECIMAL(4, 2)) )
, ( N'appdomain', 5, CAST(13.00 AS DECIMAL(4, 2)) )
, ( N'backup_restore', 1, CAST(13.00 AS DECIMAL(4, 2)) )
, ( N'broker', 42, CAST(13.00 AS DECIMAL(4, 2)) )
, ( N'cdc_logscan', 2, CAST(13.00 AS DECIMAL(4, 2)) )
, ( N'change_tracking', 2, CAST(13.00 AS DECIMAL(4, 2)) )
, ( N'checkpoint', 19, CAST(13.00 AS DECIMAL(4, 2)) )
, ( N'ckpt_close', 1, CAST(13.00 AS DECIMAL(4, 2)) )
, ( N'ckpt_controller', 9, CAST(13.00 AS DECIMAL(4, 2)) )
, ( N'ckpt_trace', 40, CAST(13.00 AS DECIMAL(4, 2)) )
, ( N'ckptworker_trace', 21, CAST(13.00 AS DECIMAL(4, 2)) )
, ( N'clr', 3, CAST(13.00 AS DECIMAL(4, 2)) )
, ( N'columnstore', 41, CAST(13.00 AS DECIMAL(4, 2)) )
, ( N'cursor', 18, CAST(13.00 AS DECIMAL(4, 2)) )
, ( N'data_masking', 3, CAST(13.00 AS DECIMAL(4, 2)) )
, ( N'database', 48, CAST(13.00 AS DECIMAL(4, 2)) )
, ( N'dbseed', 14, CAST(13.00 AS DECIMAL(4, 2)) )
, ( N'deadlock_monitor', 7, CAST(13.00 AS DECIMAL(4, 2)) )
, ( N'deploy', 17, CAST(13.00 AS DECIMAL(4, 2)) )
, ( N'errors', 24, CAST(13.00 AS DECIMAL(4, 2)) )
, ( N'exception', 6, CAST(13.00 AS DECIMAL(4, 2)) )
, ( N'execution', 119, CAST(13.00 AS DECIMAL(4, 2)) )
, ( N'extensibility_errors', 1, CAST(13.00 AS DECIMAL(4, 2)) )
, ( N'filetable', 13, CAST(13.00 AS DECIMAL(4, 2)) )
, ( N'fulltext', 8, CAST(13.00 AS DECIMAL(4, 2)) )
, ( N'garbage_collection', 1, CAST(13.00 AS DECIMAL(4, 2)) )
, ( N'gc', 4, CAST(13.00 AS DECIMAL(4, 2)) )
, ( N'hadr', 1, CAST(13.00 AS DECIMAL(4, 2)) )
, ( N'index', 9, CAST(13.00 AS DECIMAL(4, 2)) )
, ( N'init', 1, CAST(13.00 AS DECIMAL(4, 2)) )
, ( N'io', 50, CAST(13.00 AS DECIMAL(4, 2)) )
, ( N'json', 7, CAST(13.00 AS DECIMAL(4, 2)) )
, ( N'latch', 8, CAST(13.00 AS DECIMAL(4, 2)) )
, ( N'lock', 16, CAST(13.00 AS DECIMAL(4, 2)) )
, ( N'memory', 43, CAST(13.00 AS DECIMAL(4, 2)) )
, ( N'merge_trace', 27, CAST(13.00 AS DECIMAL(4, 2)) )
, ( N'oledb', 6, CAST(13.00 AS DECIMAL(4, 2)) )
, ( N'optimization', 3, CAST(13.00 AS DECIMAL(4, 2)) )
, ( N'process', 12, CAST(13.00 AS DECIMAL(4, 2)) )
, ( N'query_store', 68, CAST(13.00 AS DECIMAL(4, 2)) )
, ( N'redo', 5, CAST(13.00 AS DECIMAL(4, 2)) )
, ( N'replication', 10, CAST(13.00 AS DECIMAL(4, 2)) )
, ( N'satellite_authentication', 2, CAST(13.00 AS DECIMAL(4, 2)) )
, ( N'satellite_cargo_messages', 12, CAST(13.00 AS DECIMAL(4, 2)) )
, ( N'satellite_launchpad_communication', 5, CAST(13.00 AS DECIMAL(4, 2)) )
, ( N'scheduling', 26, CAST(13.00 AS DECIMAL(4, 2)) )
, ( N'security', 9, CAST(13.00 AS DECIMAL(4, 2)) )
, ( N'server', 23, CAST(13.00 AS DECIMAL(4, 2)) )
, ( N'session', 31, CAST(13.00 AS DECIMAL(4, 2)) )
, ( N'storage_management', 23, CAST(13.00 AS DECIMAL(4, 2)) )
, ( N'stretch', 62, CAST(13.00 AS DECIMAL(4, 2)) )
, ( N'synchronization', 2, CAST(13.00 AS DECIMAL(4, 2)) )
, ( N'task', 2, CAST(13.00 AS DECIMAL(4, 2)) )
, ( N'temporal', 14, CAST(13.00 AS DECIMAL(4, 2)) )
, ( N'transaction', 14, CAST(13.00 AS DECIMAL(4, 2)) )
, ( N'transactions', 53, CAST(13.00 AS DECIMAL(4, 2)) )
, ( N'transmitter', 9, CAST(13.00 AS DECIMAL(4, 2)) )
, ( N'transport', 10, CAST(13.00 AS DECIMAL(4, 2)) )
, ( N'ucs', 8, CAST(13.00 AS DECIMAL(4, 2)) )
, ( N'unload', 1, CAST(13.00 AS DECIMAL(4, 2)) )
, ( N'warnings', 7, CAST(13.00 AS DECIMAL(4, 2)) )
, ( N'xtp', 31, CAST(13.00 AS DECIMAL(4, 2)) )
, ( N'xtp_encryption', 3, CAST(13.00 AS DECIMAL(4, 2)) )
, ( N'xtp_io_governance', 2, CAST(13.00 AS DECIMAL(4, 2)) )
, ( N'_UnAssigned', 5, CAST(10.00 AS DECIMAL(4, 2)) )
, ( N'access_methods', 6, CAST(10.00 AS DECIMAL(4, 2)) )
, ( N'broker', 73, CAST(10.00 AS DECIMAL(4, 2)) )
, ( N'cdc_logscan', 2, CAST(10.00 AS DECIMAL(4, 2)) )
, ( N'change_tracking', 1, CAST(10.00 AS DECIMAL(4, 2)) )
, ( N'clr', 2, CAST(10.00 AS DECIMAL(4, 2)) )
, ( N'cursor', 11, CAST(10.00 AS DECIMAL(4, 2)) )
, ( N'database', 21, CAST(10.00 AS DECIMAL(4, 2)) )
, ( N'deadlock_monitor', 6, CAST(10.00 AS DECIMAL(4, 2)) )
, ( N'errors', 5, CAST(10.00 AS DECIMAL(4, 2)) )
, ( N'exception', 3, CAST(10.00 AS DECIMAL(4, 2)) )
, ( N'execution', 14, CAST(10.00 AS DECIMAL(4, 2)) )
, ( N'io', 20, CAST(10.00 AS DECIMAL(4, 2)) )
, ( N'latch', 4, CAST(10.00 AS DECIMAL(4, 2)) )
, ( N'lock', 6, CAST(10.00 AS DECIMAL(4, 2)) )
, ( N'memory', 12, CAST(10.00 AS DECIMAL(4, 2)) )
, ( N'process', 12, CAST(10.00 AS DECIMAL(4, 2)) )
, ( N'replication', 7, CAST(10.00 AS DECIMAL(4, 2)) )
, ( N'scheduling', 21, CAST(10.00 AS DECIMAL(4, 2)) )
, ( N'server', 21, CAST(10.00 AS DECIMAL(4, 2)) )
, ( N'synchronization', 1, CAST(10.00 AS DECIMAL(4, 2)) )
, ( N'transactions', 2, CAST(10.00 AS DECIMAL(4, 2)) )
, ( N'_UnAssigned', 26, CAST(11.00 AS DECIMAL(4, 2)) )
, ( N'access_methods', 18, CAST(11.00 AS DECIMAL(4, 2)) )
, ( N'alwayson', 97, CAST(11.00 AS DECIMAL(4, 2)) )
, ( N'broker', 42, CAST(11.00 AS DECIMAL(4, 2)) )
, ( N'cdc_logscan', 2, CAST(11.00 AS DECIMAL(4, 2)) )
, ( N'change_tracking', 2, CAST(11.00 AS DECIMAL(4, 2)) )
, ( N'clr', 3, CAST(11.00 AS DECIMAL(4, 2)) )
, ( N'cursor', 18, CAST(11.00 AS DECIMAL(4, 2)) )
, ( N'database', 40, CAST(11.00 AS DECIMAL(4, 2)) )
, ( N'deadlock_monitor', 6, CAST(11.00 AS DECIMAL(4, 2)) )
, ( N'errors', 19, CAST(11.00 AS DECIMAL(4, 2)) )
, ( N'exception', 4, CAST(11.00 AS DECIMAL(4, 2)) )
, ( N'execution', 106, CAST(11.00 AS DECIMAL(4, 2)) )
, ( N'filetable', 13, CAST(11.00 AS DECIMAL(4, 2)) )
, ( N'fulltext', 8, CAST(11.00 AS DECIMAL(4, 2)) )
, ( N'garbage_collection', 1, CAST(11.00 AS DECIMAL(4, 2)) )
, ( N'hadr', 1, CAST(11.00 AS DECIMAL(4, 2)) )
, ( N'index', 9, CAST(11.00 AS DECIMAL(4, 2)) )
, ( N'init', 1, CAST(11.00 AS DECIMAL(4, 2)) )
, ( N'io', 21, CAST(11.00 AS DECIMAL(4, 2)) )
, ( N'latch', 6, CAST(11.00 AS DECIMAL(4, 2)) )
, ( N'lock', 11, CAST(11.00 AS DECIMAL(4, 2)) )
, ( N'memory', 34, CAST(11.00 AS DECIMAL(4, 2)) )
, ( N'oledb', 5, CAST(11.00 AS DECIMAL(4, 2)) )
, ( N'process', 12, CAST(11.00 AS DECIMAL(4, 2)) )
, ( N'replication', 8, CAST(11.00 AS DECIMAL(4, 2)) )
, ( N'scheduling', 24, CAST(11.00 AS DECIMAL(4, 2)) )
, ( N'security', 3, CAST(11.00 AS DECIMAL(4, 2)) )
, ( N'server', 15, CAST(11.00 AS DECIMAL(4, 2)) )
, ( N'session', 14, CAST(11.00 AS DECIMAL(4, 2)) )
, ( N'storage_management', 1, CAST(11.00 AS DECIMAL(4, 2)) )
, ( N'synchronization', 2, CAST(11.00 AS DECIMAL(4, 2)) )
, ( N'task', 2, CAST(11.00 AS DECIMAL(4, 2)) )
, ( N'transactions', 46, CAST(11.00 AS DECIMAL(4, 2)) )
, ( N'transmitter', 9, CAST(11.00 AS DECIMAL(4, 2)) )
, ( N'transport', 9, CAST(11.00 AS DECIMAL(4, 2)) )
, ( N'ucs', 1, CAST(11.00 AS DECIMAL(4, 2)) )
, ( N'warnings', 7, CAST(11.00 AS DECIMAL(4, 2)) );
IF OBJECT_ID('tempdb.dbo.#presel') IS NOT NULL
BEGIN
DROP TABLE #presel;
END
SELECT oc.name AS EventName
, oc.description AS column_description
, ca.map_value AS SearchKeyword
, @ServerMajorVersion AS SQLVersion
INTO #presel
FROM sys.dm_xe_objects oc
OUTER APPLY ( SELECT mv.map_value
FROM sys.dm_xe_object_columns occ
INNER JOIN sys.dm_xe_map_values mv
ON occ.type_name = mv.name
AND occ.column_value = mv.map_key
AND occ.object_package_guid = mv.object_package_guid
WHERE occ.name = 'KEYWORD'
AND occ.object_name = oc.name
) ca
WHERE oc.object_type = 'event';
/* version specific features */SELECT *
FROM #XECounts xc
WHERE xc.SQLVersion = @ServerMajorVersion
AND xc.Feature NOT IN ( SELECT Feature
FROM #XECounts x
WHERE x.SQLVersion < @ServerMajorVersion );
/* change in feature counts*/SELECT xv.Product
, xc.Feature
, xc.FeatureEventCount
, ISNULL(fo.FeatureEventCount, 0) AS PreviousEditionCount
, xc.FeatureEventCount - ISNULL(fo.FeatureEventCount, 0) AS NewEventCount
, CASEWHEN ISNULL(fo.Feature, '') = '' THEN 'New Feature'
ELSE 'Existing Feature'
END AS NewOrOld
FROM #XECounts xc
INNER JOIN #XEVersions xv
ON xc.SQLVersion = xv.ServerMajorVersion
FULL OUTER JOIN ( SELECT x2.Feature
, x2.FeatureEventCount
FROM #XECounts x2
INNER JOIN #XEVersions xev
ON x2.SQLVersion = xev.ServerMajorVersion
WHERE xev.VersionID = ( SELECT VersionID - 1
FROM #XEVersions x
WHERE x.ServerMajorVersion = @ServerMajorVersion
)
) fo
ON xc.Feature = fo.Feature
WHERE 1 = 1
AND xc.SQLVersion = @ServerMajorVersion;
/* specific counts for the current server just in case new events rolled out with a patch*/SELECT MAX(xev.Product) AS Product
, ISNULL(ou.Feature, '        Grand Total') AS FeatureCount
, SUM(ou.FeatureEventCount) AS FeatureEventCount
FROM ( SELECT ISNULL(p.SearchKeyword, '_UnAssigned') AS Feature
, COUNT(*) AS FeatureEventCount
, p.SQLVersion
FROM #presel p
GROUP BY p.SearchKeyword, p.SQLVersion
) ou
INNER JOIN #XEVersions xev
ON ou.SQLVersion = xev.ServerMajorVersion
GROUP BY ou.Feature WITH ROLLUP;

In the preceding query, I have provided an aggregation of the events and features across multiple editions of SQL Server. This aggregate of data is necessary to help see how the features are changing and how the events are changing within the features that remain constant from one version to the next.

Once that data is aggregated, I then provide a couple of sample queries that show what can be done with the data. I need to stress here that I have not provided an exhaustive set of queries to explore this data seven ways to Sunday. I have left those types of exercises up to the reader to explore and experiment.

The first example query shows how to pull the new features that can be “Traced” in the current version of SQL Server on which the query is being executed. The second example provides a difference count between versions of SQL Server to help illustrate the evolution of XEvents within SQL Server. The third query is a simple query to list out the number of events for each feature in your version of SQL Server.

From here, one might wish to explore all of the events that are related to a specific feature. This would be easily accomplished by querying out the data from the #presel temp table based on the feature name. Orrrr…one could query the desired feature by following the guidelines in this article.

Conclusion

In the article today, I have shown how it is possible to see the new events and how they relate to the various features within SQL Server. Being able to correlate events that can trap information about new features can and will help you evolve into that rock-star DBA you are trying to become!

Related Posts:

Rate

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

You rated this post out of 5. Change rating

Share

Share

Rate

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

You rated this post out of 5. Change rating

Related content

Technical Article

Database Mirroring FAQ: Can a 2008 SQL instance be used as the witness for a 2005 database mirroring setup?

Question: Can a 2008 SQL instance be used as the witness for a 2005 database mirroring setup? This question was sent to me via email. My reply follows. Can a 2008 SQL instance be used as the witness for a 2005 database mirroring setup? Databases to be mirrored are currently running on 2005 SQL instances but will be upgraded to 2008 SQL in the near future.

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

You rated this post out of 5. Change rating

2009-02-23

1,567 reads

Technical Article

Networking - Part 4

You may want to read Part 1 , Part 2 , and Part 3 before continuing. This time around I'd like to talk about social networking. We'll start with social networking. Facebook, MySpace, and Twitter are all good examples of using technology to let...

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

You rated this post out of 5. Change rating

2009-02-17

1,530 reads

Technical Article

Speaking at Community Events - More Thoughts

Last week I posted Speaking at Community Events - Time to Raise the Bar?, a first cut at talking about to what degree we should require experience for speakers at events like SQLSaturday as well as when it might be appropriate to add additional focus/limitations on the presentations that are accepted. I've got a few more thoughts on the topic this week, and I look forward to your comments.

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

You rated this post out of 5. Change rating

2009-02-13

360 reads