In simple terms, SQL Server middleware—such as OLE DB or .NET providers
and ODBC and Java Database Connectivity (JDBC) database access drivers—provides
a connection between an application and a database.The SQL Server middleware
processes application requests and presents them to a back-end database in a
language, structure, or syntax that conforms to the requirements of the database
server, then returns the data to the application.
Recently, I've been working with a consulting client to help them tame CPU usage. Typically, they're clocking over 20,000 queries and operations per second on their e-commerce SQL Server, but ran into an issue where CPU started spiking up above 90 percent for sustained periods of time....More
What should most database administrators be doing on a regular basis? Here's a comprehensive list from Michael K. Campbell of many of the things DBAs typically do on a daily, weekly, monthly, and yearly basis....More