????OLEDB?????????SQL SERVER ??????г??????????????????????ζ?????????SPID?????SQL Server Native Client OLEDB Provider????????????????????????????????????????????????remote system ?????????????????????????????????????????????????????OLEDB???????????????Щ????????????????????Щ???????
????1????????????Remote procedure calls??
????2????????????????Linked server queries??
????3??BULK INSERT commands
????4??Full-search queries ??????????????????Excel
????5????????Profiler????(Client-side Profiler traces)
????6??DMV?? log reader and DBCC CHECKDB
????????DBCC CHECKDB??????OLEDB???????????????ú???????????????????????ú??????????DPA??Database Performance Analyzer???????????SQL 2012??SQL 2014??????DBCC CHECKDB?????OLEDB??????????????????????????????????????????????????????????DBCC CHECKDB????? OLEDB ?м?????????????洢???????????佻???????
??????????????DBCC CHECKDB????OLEDB?????????????
????--SESSION 1
????DBCC SQLPERF('sys.dm_os_wait_stats'?? CLEAR);
????GO
????DBCC CHECKDB('AdventureWorks2014');
????--SESSION 2
????SELECT * FROM
????sys.dm_os_wait_stats
????WHERE wait_type='OLEDB'
????clipboard

??????DBCC CHECKDB???????????????2?У?????OLEDB????????waiting_tasks_count??wait_time_ms?????????????DBCC CHECKDB??????OLEDB???????????DPA??????????SQL Server 2012??SQL Server 2014???????SQL Server 2005?? SQL Server 2008????????????????????SQL SERVER 2012/2014??DBCC CHECKDB?????????Bug?????????ο???????SQL Server 2014 Service Pack 1 release information ??????????????????Fix????????????DBCC CHECKDB??Bug???????????????Щ?????????????DBCC CHECKDB?????OLEDB?????????
???????????DMV??????OLEDB?????????????DMV????????OLEDB??????Щ????????????DMV????3?????OLEDB????????
????OLEDB?????????
????1??????ò??濼??????????????κ?????????????紫?????????????????OLEDB?????????????????????????????
????2????????Linked Server????????????????????????????Щ??????????????????????????б??????????????????????????????仯?????????????????????????????????????????????????
????3??????????????????????????????????????????б??????Щ???????????Щ???????????? ????????????濼?????????罫??Щ?????????????
????4???????Щ???????Excel?????????????????FTP??????????????????????????????
????5: ?????????????????SQL????????????????????????????????????????Щ????????????????????????????洢?????????????????????????????????????????
????SELECT * FROM
????linked_server.dbo.table_a  inner join ..
????linked_server.dbo.table_b  inner join ..
????linked_server.dbo.table_c  inner join ..
????.......................
????6???????????????????????????????????????????????????????????????OLEDB??????????????