You will get an SQL Server health check and assessment
Project details
An efficient server configuration and healthy database are essential for staff productivity, customer satisfaction and keeping your company’s efficiency high.
When your database slows down, your company suffers and many businesses are unsure about the situation.
The following main check will proceed during the health check and assessment.
1. Hardware configuration: Assigned CPUs, memory buffer and IO system and available storage.
2. Server configuration: tempdb, backups, latencies, server lever highly resources consumed queries.
3. Database level: last backups, poorly executing queries and stored procedures. missing or bad indexes and its fragmentations and statistics.
and finally you will have a summary and Action plan.
Best practices for SQL servers:
======================
1. Conduct general health checks every 6 to 12 months
2. Create documentation
3. Identify all the health issues during the health check and then develop a remediation plan.
When your database slows down, your company suffers and many businesses are unsure about the situation.
The following main check will proceed during the health check and assessment.
1. Hardware configuration: Assigned CPUs, memory buffer and IO system and available storage.
2. Server configuration: tempdb, backups, latencies, server lever highly resources consumed queries.
3. Database level: last backups, poorly executing queries and stored procedures. missing or bad indexes and its fragmentations and statistics.
and finally you will have a summary and Action plan.
Best practices for SQL servers:
======================
1. Conduct general health checks every 6 to 12 months
2. Create documentation
3. Identify all the health issues during the health check and then develop a remediation plan.
Database Type
MS SQLWhat's included
| Service Tiers |
Starter
$100
|
Standard
$200
|
Advanced
$300
|
|---|---|---|---|
| Delivery Time | 1 day | 2 days | 5 days |
Number of Revisions | 3 | 3 | 3 |
Number of Queries | 90 | 90 | 90 |
Query Debugging | - | - | - |
Query Optimization | - | - | - |
Query Scheduling | - | - | - |
Query Analysis | |||
Source Code | - | - | - |
Optional add-ons
You can add these on the next page.
Query Optimization
(+ 1 Day)
+$30About Niaz
Senior SQL Database Admin & Azure Data Expert
Kohat, Pakistan - 1:34 am local time
SQL, PowerShell
SSIS, SSRS
SQL SPs
Query tuning
AWS RDS instances,
HA & DR Solutions
Server/Database Configuration
Health Check assessment
Data Engineering
Python (pandas, Numpy), PySpark, PS, SQL, Jupyter notebooks
Data Modeling, Data Mart, Azure Synapse, Snowflake
DataChannel, Hevo Data, Talend, Power BI
Steps for completing your project
After purchasing the project, send requirements so Niaz can start the project.
Delivery time starts when Niaz receives requirements from you.
Niaz works on your project following the steps below.
Revisions may occur after the delivery date.
Step 1.
You accept the offer and purchase this project.
Step 2.
At your feasible time, you will provide and RDP-based application like TeamViewer etc to connect me.