SQL Server Profiler 跟蹤不斷出現檢索資料

     用SQL Server Profiler跟蹤SQL的時候,老是出現下面的執行.而且不間斷,隔幾秒就會出現一次,很是惱火.找了半天,發現是

ReportServer資料庫裡面的表.但是總不能刪掉這個資料庫把.後來網上找了下,關掉Report服務就行了,開啟Reporting Services

組態管理員,停掉服務,總算清靜了.繼續最佳化項目.

declare @BatchID uniqueidentifier

set @BatchID = newid()

UPDATE [Notifications] WITH (TABLOCKX)
SET [BatchID] = @BatchID,
[ProcessStart] = GETUTCDATE(),
[ProcessHeartbeat] = GETUTCDATE()
FROM (
SELECT TOP 4  [NotificationID] FROM [Notifications] WITH (TABLOCKX) WHERE ProcessStart is NULL and
                                        (ProcessAfter is NULL or ProcessAfter < GETUTCDATE()) ORDER BY [NotificationEntered]
                                    ) AS t1
WHERE [Notifications].[NotificationID] = t1.[NotificationID]

select top 4
-- Notification data
                                            N.[NotificationID],
                                            N.[SubscriptionID],
                                            N.[ActivationID],
                                            N.[ReportID],
                                            N.[SnapShotDate],
                                            N.[DeliveryExtension],
                                            N.[ExtensionSettings],
                                            N.[Locale],
                                            N.[Parameters],
                                            N.[SubscriptionLastRunTime],
                                            N.[ProcessStart],
                                            N.[NotificationEntered],
                                            N.[Attempt],
                                            N.[IsDataDriven],
SUSER_SNAME(Owner.[Sid]),
                                            Owner.[UserName],
-- Report Data
                                            O.[Path],
                                            O.[Type],
                                            SD.NtSecDescPrimary,
                                            N.[Version],
                                            Owner.[AuthType]
from 
[Notifications] N with (TABLOCKX) inner join [Catalog] O on O.[ItemID] = N.[ReportID]
inner join [Users] Owner on N.SubscriptionOwnerID = Owner.UserID
left outer join [SecData] SD on O.[PolicyID] = SD.[PolicyID] AND SD.AuthType = Owner.AuthType
where 
                                            N.[BatchID] = @BatchID
ORDER BY [NotificationEntered]