Home Forums SQL Server 2005 Administering sql server 2005 sp1 is slow RE: sql server 2005 sp1 is slow
george sibbald
SSC Guru
Points: 104210
More actions
July 19, 2013 at 2:33 pm
#1634198
as the message says it is an advanced setting
sp_CONFIGURE 'show advanced options',1
RECONFIGURE
GO
sp_CONFIGURE ‘optimize for ad hoc workloads’,1
---------------------------------------------------------------------