Itās hugely varied⦠in my experience, some 90% or more is virtualizedā¦
So you have e.g. VMware ESX (using Photon Linux O/S) hypervisors, which also host VMware management VMs to do more sophisticated VMware stuff, like vSphere and/or vCenter (e.g. you can vMotion a virtual server from one ESXi host, to another - very useful when e.g. replacing an ESXi blade in a blade chassis).
Those ESXi hosts, host virtual servers, running x86 and x86_64 with Windows and Linux servers, occasionally BSD and Solaris x86.
Some of those VMs might be RDBMS servers running MS SQL Server, or Oracle RDBMS (usually on Linux, but it is possible to run Oracle DB on Windows servers too).
There are still Solaris out there hosting legacy stuff, I havenāt seen Solaris 8 or 9 recently, but have one customer still running solaris 10, and 11, on Oracle branded Sparc T series systems, and to further confused matters, some of those are running on āmetalā and hosting hypervisors (Sun / Oracle T series have built in hypervisors) which then host virtual Solaris servers or "LDOM"s (Logical Domains) - and the further abstracted, when some of these LDOMs then host multiple containers, or Solaris Zones (i.e. kinda sorta like docker).
These are routers, and switches and firewalls⦠Cisco still the biggest player in that space, AFAIK, their first devices were actually on Sun boxes running UNIX⦠Theyāre generally not considered āserversā as such, in many cases, these are also run as āappliancesā on a virtualization platform (typically VMware, but also HyperV, KVM, Oracle VM).
Note - thereās also āserverlessā computing⦠e.g. you can deploy a virtual server in Amazon EC2, but it can use a database hosted in Amazon RDS, but you NEVER get access to the server hosting this database, itās serverless (you can do PostgreSQL, MS SQL, Oracle DB, MariaDB, MySQL etc)⦠There are many other things that Amazon provide in the serverless space, like messaging, and things like Kafkaā¦
Many organisations are ādownsizingā their managed infrastructure - i.e. migrating their stuff to the cloud (mostly Amazon AWS and Microsoft Azure).
But there are still many organizations and companies that have their equipment stored in Data Centres - many will have or use, two data centres. This are massive buildings with all the stuff needed to host servers.
Most customers will rent a certain amount of floorspace in one of these DCās (Data Centres) - these are often called Data Halls, or ācagesā - however some customers with smaller requirements, maybe have to share their ādata hallā with the racks used by othersā¦
In nearly all cases, working in these DCās is A HUGE PITA! I canāt really spend more than a couple of hours at anyone time - because the aircon sucks ALL the moisture from your body, so you have to constantly re-hydrate (but you canāt take ANY liquid containers into the data halls) - so constantly having to locate one of the āBreak Outā rooms, that usually have free WiFi and food vending machines, and coffee making facilitiesā¦