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
Advanced search options...
Search In:
Everything
Blogs
Forums
People
Groups
Places
Pages
Date range:
All Time
Last Year
Last 6 Months
Last 3 Months
Last Month
Last Week
Last Two Days
Tags
Data Collector
Database Mail
Powershell
Proxy
quoted_identifier
Scheduler
SQL Agent
Sql Agent History
SQL Agent Logger
SQL Agent Scheduler
SQL Azure
SQL Server Agent
XEvent
Monthly Archives
Archives
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
Data Collector's sp_purge_data may run for hours if there are many orphaned plans to purge
Posted
over 1 year 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...
Microsoft SQL Server Front End Blog
Auditing changes done to syscollector_execution_log_internal & tracking root cause of Error 14262
Posted
over 1 year 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...
Page 1 of 1 (2 items)