Scribd
Upload
5 views2 pages

SQL Server RAP Assessment Questionnaire

The document is a questionnaire for SQL Server RAP as a Service, collecting essential information about the company's SQL Server environment, including general details, security and compliance measures, backup and recovery strategies, performance monitoring, and high availability/disaster recovery setups. It seeks specific data on instances, versions, authentication modes, backup solutions, and any ongoing issues or upcoming projects. This information is crucial for assessing the SQL Server environment and planning the RAP execution.

Uploaded by

Yogendera2893
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
5 views2 pages

SQL Server RAP Assessment Questionnaire

The document is a questionnaire for SQL Server RAP as a Service, collecting essential information about the company's SQL Server environment, including general details, security and compliance measures, backup and recovery strategies, performance monitoring, and high availability/disaster recovery setups. It seeks specific data on instances, versions, authentication modes, backup solutions, and any ongoing issues or upcoming projects. This information is crucial for assessing the SQL Server environment and planning the RAP execution.

Uploaded by

Yogendera2893
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd

■ SQL Server RAP as a Service – Environment Questionnaire

1. General Information

Company / Business Unit: ____________________________

Primary Contact (Name/Email/Phone): ____________________________

Support Agreement Type (Unified / Premier): ____________________________

Preferred RAP Execution Window (Date/Time): ____________________________


2. Environment Overview

Approximate number of SQL Server instances: ____________________________

Versions in use (e.g., SQL 2012, 2016, 2019, 2022): ____________________________

Editions in use (Enterprise, Standard, Express): ____________________________

Operating system versions for SQL Servers: ____________________________

Are servers on-premises, cloud, or hybrid? ____________________________

Clustered / Always On Availability Groups in use? (Yes/No, details): ____________________________


3. Security & Compliance

Are SQL Servers joined to a domain? (Yes/No) ____________________________

Authentication mode used (Windows / Mixed): ____________________________

Are sysadmin accounts controlled and audited? ____________________________

Is Transparent Data Encryption (TDE) enabled on any databases? ____________________________

Are compliance frameworks in scope (HIPAA, GDPR, PCI-DSS, SOX)? ____________________________


4. Backup & Recovery

Backup solution used (Native SQL, 3rd party, etc.): ____________________________

Backup frequency (Full/Differential/Log): ____________________________

Typical Recovery Point Objective (RPO): ____________________________

Typical Recovery Time Objective (RTO): ____________________________

Has a restore test been performed in the last 6 months? (Yes/No) ____________________________
5. Performance & Monitoring

Is performance monitoring in place? (PerfMon, Extended Events, 3rd party tools): ____________________________

Typical workload type (OLTP, DW/Analytics, Mixed): ____________________________

Any recurring performance issues (blocking, slow queries, deadlocks)? ____________________________

Current monitoring/alerting solution: ____________________________


6. High Availability / Disaster Recovery (HA/DR)

What HA/DR technologies are used (Failover Clustering, AGs, Log Shipping, Replication, Mirroring, Cloud-based DR)? ______

Where are DR servers located (on-prem, secondary datacenter, cloud)? ____________________________

Date of last failover test: ____________________________

Known HA/DR gaps or risks: ____________________________


7. Additional Notes

Known business-critical databases (names, functions): ____________________________

Any ongoing SQL Server issues (security, performance, availability): ____________________________

Upcoming projects/upgrades (e.g., migration to newer SQL Server version, Azure SQL): ____________________________

Any restrictions for RAP collector execution (change management approvals, restricted accounts): ______________________

You might also like