There are several ways to find out, or some make an estimate at, when a SQL Instance started. Can anyone say how accurate this query would be?
On all my instances it seem to be pretty accurate but I'm wondering if there is any reason not to use this? It seems a lot simpler than checking the create date of TempDB and various other ways I know of ...
asked Nov 23, 2011 at 05:56 AM in Default
Only for SQL 2008 an above, but this would be better:
I'm not sure how accurate the
EDIT 2: Drop clean buffers doesn't change the entries of
p.s. don't test this assumption on a prod box. I didn't..... honest.....
I think it'll probably work. I'd call it an undocumented artifact and I wouldn't want to base major assumptions on it that affect my pay check or something like that, but yeah, I think it'll work.
answered Nov 23, 2011 at 10:43 AM
Grant Fritchey ♦♦
I have compiled what is mentioned in this question and in this blog and run it on my machine:
All give a slightly different result. I usually use the first and the last one.
answered Dec 10, 2011 at 11:47 AM
Another way... and it won't work for everyone as some people use daily error logs etc.
This basically returns when the system was ready.
Not a solution I would go with to base everything on but it does show that there are always alternatives :)
answered Nov 24, 2011 at 07:20 AM
you can get instance startime by simply quering tempdb creation time.
answered Dec 09, 2011 at 08:44 PM