SQLLawman

I love it when I learn something within a half hour of getting to work.  I had an unrelated alert on a vendor supplied database server.  As I was investigating that problem I came across two things.  One was funny, one I actually learned something.  First the funny: they had named the sysadmin account ‘God’.  Wasn’t that from the terrifically awesome, how can I live without seeing that one, movie ‘Hackers?’  But now onto what I learned.  I looked at the SQL Server Log and I had hundreds of entries that said “Starting up database ‘DbName’” These were appearing several time a second.  I’m thinking.  This has got to be a waste of precious CPU.  I know the server site at 10% utilized even when the two people we bought it for are using it, but that’s beside the point.  Its CPU darn it.  Well, I have to admit that message meant nothing to me.  So I asked my favorite co-worker, Mr. Google, what was up.  He told me the server is set to Auto Close.  I looked at the options and he, of course, was right.  Auto shrink was enabled also.  So, I fixed those two issues and now the database server is chugging along at 9.98% utilized.  It’s only 7:44 am and I believe my work is done here.  Time to twitter for the next few hours till quitting time.  Crap, it only works that way in movies.  Another database needs my care.