April 28, 2010 at 11:15 am
I was wondering if anyone has a rough idea of how many licensed sql instances there are out there.. maybe broken down by version and country..
just curious 🙂
thanks
--------------------------
I long for a job where my databases dont have any pesky users accessing them 🙂
April 28, 2010 at 12:02 pm
Probably not as many as there are total (licensed plus unlicensed).
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
April 28, 2010 at 12:05 pm
This doesn't provide the answer either, but one could extrapolate.
http://www.networkworld.com/community/node/31719
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
April 28, 2010 at 12:09 pm
This reminds me of a sign I saw in the Frankfurt Airport a few years ago "97% of the Fortune 500 use Oracle"
I'd bet that somewhere, in some department, 99% of the Fortune 500 use SQL.
The point is there are enterprise SQL apps and servers, then most companies have, in my experience, dozens of smaller SQL boxes running something, somewhere.
/* ----------------------------- */
Tochter aus Elysium, Wir betreten feuertrunken, Himmlische, dein Heiligtum!
April 28, 2010 at 12:34 pm
i've no doubt that SQL Server boxes are scattered amongst companies, even though supposedly Oracle or AS400 shops - and i've absolutely no doubt at all that theres a good number of unlicensed sql installs out there..
my curiosity is along the lines of what is average.. whats an average number of sql server instances for a small-mid size business nowadays? how many of these are mission critical (as opposed to just random dumping grounds) - i know a previous employer of mine had about 40 instances, but only about 25 were really what we'd class as mission critical - the others were unconsolidated databases from 3rd party apps and the like..
perhaps I should have put a poll on the post..
--------------------------
I long for a job where my databases dont have any pesky users accessing them 🙂
April 28, 2010 at 12:39 pm
two companies ago (where we had a very thorough inventory), we had
675 instances on 195 servers (this included dev/qa/prod/dr)
last company, had over 2600 instances scattered on over 1,000 servers
Both are fortune 500
/* ----------------------------- */
Tochter aus Elysium, Wir betreten feuertrunken, Himmlische, dein Heiligtum!
April 28, 2010 at 12:43 pm
yowzer.. thats a lot of instances to keep track of..
i'd be interested in hearing from anyone from small-mid size businesses as well though.. some interesting numbers out there i bet 🙂
--------------------------
I long for a job where my databases dont have any pesky users accessing them 🙂
April 28, 2010 at 12:43 pm
I worked for a small company years ago (2002) and we had 5 instances of the server, I'd consider crucial. Numerous Personal editions, but on servers we had
1. Primary web backing instance
2. QA instance
3. Test/Dev instance
4. Accounting instance.
In a large F500 company (JD Edwards), we had over 250 servers running SQL. This was when multi-instancing wasn't really used with SQL 2000.
These days I suspect that the number changes constantly with test/dev/qa virtual instances. In terms of crucial, I found at Peoplesoft, where we had hundreds of instances of SQL, along with DB2 and Oracle, only about a dozen were critical. The rest were important to groups, but not the whole company.
April 28, 2010 at 6:29 pm
In Fortune 500's I see the number of databases and instances getting very large quite easily. I worked for one where we had ~6000 instances in production (that excludes dev and qa). It was a substantial amount of servers to manage.
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
Viewing 9 posts - 1 through 8 (of 8 total)
You must be logged in to reply to this topic. Login to reply