You are a database administrator for your company. The company uses a SQL Server 2005 application. Each night, data is imported into a database, and the database is then set to be read-only. During business hours, users run predefined and ad hoc queries. You need to monitor the servers performance during the day. What are two possible ways to achieve this goal?()
- AUse the Lock Waits/sec performance counter.
- BUse the Number of Deadlocks/sec performance counter.
- CUse the Transactions/sec performance counter.
- DUse the Full Scans/sec performance counter.
- EUse the Batches/sec performance counter.