SQL Server 2012 SP3

Question

SQL Server 2012 SP3

Viewing 3 posts - 16 through 17 (of 17 total)

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

rogelio.vidaurri SSCrazy Points: 2117 More actions · Answer 1

well Eirikur, I'm running the "Check the integrity of all user databases" on UAT and it's been there for half an hour
good thing I don't see blocking processes!

NorthernSoul SSCertifiable Points: 6869 More actions · Answer 2

rogelio.vidaurri - Thursday, July 6, 2017 2:50 PM
well Eirikur, I'm running the "Check the integrity of all user databases" on UAT and it's been there for half an hour
good thing I don't see blocking processes!

You need to make sure you run integrity checks against your production databases. How would you know if one of your databases was corrupted? Either do this during a quiet period on your databases or backup and restore them to a different server and run your integrity checks then.

You will probably see that SQL Server uses all 60gb that you allocate to it but this is normal behaviour and nothing to worry about. As Eirikur said monitor SQL logs and the OS for any memory related errors you may then need to increase memory on the server.

Thanks

rogelio.vidaurri SSCrazy Points: 2117 More actions · Answer 3

NorthernSoul - Friday, July 7, 2017 1:12 AM
rogelio.vidaurri - Thursday, July 6, 2017 2:50 PM
well Eirikur, I'm running the "Check the integrity of all user databases" on UAT and it's been there for half an hour
good thing I don't see blocking processes!
You need to make sure you run integrity checks against your production databases. How would you know if one of your databases was corrupted? Either do this during a quiet period on your databases or backup and restore them to a different server and run your integrity checks then.
You will probably see that SQL Server uses all 60gb that you allocate to it but this is normal behaviour and nothing to worry about. As Eirikur said monitor SQL logs and the OS for any memory related errors you may then need to increase memory on the server.
Thanks

great, thanks!
we installed all windows updates and SQL SP3 last night, and also limited the memory for SQL

we'll keep an eye on everything and start running integrity checks periodically