Answer Posted / Himanshu Srivastava
SQL Server Operating System (SQLOS) is a lightweight operating system built within SQL Server that manages resources like memory, CPU, and I/O for multiple user connections simultaneously.n
1. Resource Governance: Manages resource consumption by individual queries or plans to ensure fairness and prevent runaway queries from consuming all server resources.n
2. Concurrency Control: Ensures concurrent access to database objects by implementing mechanisms like locks and latches.n
3. Asynchronous Processing: Supports asynchronous processing for I/O, queries, and jobs using worker threads and worker thread pools.
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
Can you index views?
How can I check that whether automatic statistic update is enabled or not?
How to rebuild the master database?
What are the source of constraints?
When should you use an instead of trigger?
What are the different subsets of sql?
How can you append an identity column to a temporary table?
How to enter binary string literals in ms sql server?
Can we do dml on views?
How raid can influence database performance?
Equi join and non equi join is possible with sql server?
do you know how to configure db2 side of the application? : Sql server database administration
Can one drop a column from a table?
Why should you use or avoid select * statements?
What are the pros and cons of putting a scalar function in a queries select list or in the where clause?
