Interview Questions
1. Name at least three output columns of sp_monitor?
- This procedures displays statistics about Microsoft SQL Server
- last_run: Time sp_monitor was last run.
- current_run: Time sp_monitor is being run.
- Seconds: Number of elapsed seconds since sp_monitor was run.
- cpu_busy: Number of seconds that the server computer’s CPU has been doing SQL Server work.
- io_busy: Number of seconds that SQL Server has spent doing input and output operations.
- Idle: Number of seconds that SQL Server has been idle.
- packets_received: Number of input packets read by SQL Server.
- packets_sent: Number of output packets written by SQL Server.
- packet_errors: Number of errors encountered by SQL Server while reading and writing packets.
- total_read: Number of reads by SQL Server. o total_write: Number of writes by SQL Server.
- total_errors: Number of errors encountered by SQL Server while reading and writing.
- Connections: Number of logins or attempted logins to SQL Server.
Submit an interview question
Submitted questions and answers are subject to review and editing, and may or may not be selected for posting, at the sole discretion of w3Sniff.
Get Started
Comments
Leave a Comment