Link to home
Start Free TrialLog in
Avatar of s_sykes
s_sykesFlag for United States of America

asked on

SQL Server 2012 Service Pack 1

I just moved my database over to SQL Server 2012 last month from a shared SQL 2005 box maintained by someone else.  It took awhile but now everything is up and running smoothly.  Should I now apply SQL Server 2012 Service Pack 1 or leave things alone?

I'm not real familiar with maintaining a SQL Server, so I'm reluctant to install a major update with things running well.  Only thing I've noticed is that it tends to roll forward a bunch of transactions if I reboot in the evening, so I'm guessing it is slow to clear the buffer cache.  Not sure this is a problem though.  Any insight would be appreciated.

Thanks!
ASKER CERTIFIED SOLUTION
Avatar of Guy Hengel [angelIII / a3]
Guy Hengel [angelIII / a3]
Flag of Luxembourg image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of s_sykes

ASKER

Have you applied this one?  Any issues?
SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial