Sign in
Microsoft SQL Server Front End Blog
The writers of this blog are a part of the Microsoft SQL Server Manageability team. We will be blogging about our tools, scripts, webcasts, and miscellaneous tips that will help you get the most out of SQL Agent, Data collector and other tools
Translate This Page
Translate this page
Powered by
Microsoft® Translator
Common Tasks
Blog Home
Email Blog Author
OK
RSS for comments
RSS for posts
Atom
Subscribe via RSS
Search
Tags
Activity Monitor
Backup
Data Collector
Database Mail
Powershell
Proxy
quoted_identifier
reports
Scheduler
scripting
SMO
SQL Agent
Sql Agent History
SQL Agent Logger
SQL Agent Scheduler
SQL Azure
SQl Server
SQL Server 2012 SP1
SQL Server Agent
SSMS Reports
XEvent
Monthly Archives
Archives
March 2013
(1)
February 2013
(1)
January 2013
(2)
December 2012
(1)
November 2012
(2)
September 2012
(2)
August 2012
(3)
July 2012
(2)
June 2012
(1)
May 2012
(2)
April 2012
(3)
March 2012
(2)
February 2012
(1)
January 2012
(1)
November 2011
(2)
July 2011
(4)
June 2011
(1)
April 2011
(2)
March 2011
(2)
February 2011
(3)
January 2011
(6)
December 2010
(2)
November 2010
(8)
October 2010
(6)
September 2010
(2)
April, 2011
MSDN Blogs
>
Microsoft SQL Server Front End Blog
>
April, 2011
Subscribe via RSS
Sort by:
Most Recent
|
Most Views
|
Most Comments
Excerpt View
|
Full Post View
Microsoft SQL Server Front End Blog
Auditing changes done to syscollector_execution_log_internal & tracking root cause of Error 14262
Posted
over 2 years ago
by
Sethu Srinivasan
0
Comments
-- If you are not seeing random failures in following data collection job -- collection_set_1_noncached_collect_and_upload , please ignore this blog entry -- -- This script is to help our dev team understand the root cause of failed data collector job...
Microsoft SQL Server Front End Blog
Data Collector's sp_purge_data may run for hours if there are many orphaned plans to purge
Posted
over 2 years ago
by
Sethu Srinivasan
0
Comments
Here is the fix for data collector purge job taking too long to complete. Please let us know if this fix solves your problem. Please send us your feedback to sethu.srinivasan@microsoft.com . I have also attached the query as attachment to this blog entry...
Page 1 of 1 (2 items)