s_sykes
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!
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
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER