Is Reporting service needed to run SQL Server ?

Question

Is Reporting service needed to run SQL Server ?

r_chakra

Valued Member

Points: 51
More actions
June 2, 2008 at 9:12 am

#207988

Hi,
We have a SQL 2005 Server running for an OLTP application. We are not using the SQL Reporting services for any reports. However, every now and then the SQL Profiler logs this Reporting service query. Is this required in any way for my SQL Database to run , or can i shut down the Reporting service since i don't use it ?
Thanks and regards,
Chak.
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]

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply

Michael Earl-395764 SSC Guru Points: 53873 More actions · Answer 1

You can turn it off (or completely uninstall it), but the reports within Management Studio use it, so you may lose some useful features.

Just sitting there, it does not use much for resources.

Manoj-485464 SSCrazy Points: 2717 More actions · Answer 2

SQL Reporting services you installed as part of the SQL server 2k5 installation. You should be shut down the reporting services or else uninstall that from Control Pannel.

Manoj

MCP, MCTS (GDBA/EDA)