
Closed
Posted
I need Datadog monitors configured for our on-prem SQL Server estate and cloud databases. The goal is to have actionable alerts in place for: • Performance thresholds (CPU, memory, waits, long-running queries) • Error occurrences drawn from the SQL Error Log • Resource utilization across disks, tempdb, and buffer cache • Agent job failures and long runtimes • AlwaysOn AG health, including role changes and replica sync state • Server-offline or heartbeat loss I already have the Datadog agent running on the hosts; what I’m missing are the right queries, monitor definitions, and alert channels. Your work should include creating the monitors, testing each one to prove it fires and clears correctly, and documenting any custom queries or variables you add so we can maintain them after hand-off. Deliverables 1. Datadog monitor definitions (JSON export or Terraform, whichever you prefer) covering all alert types listed above. 2. A short runbook that explains the metrics, thresholds, and expected responses. 3. A brief hand-over session or recording showing the monitors firing in a test scenario. Acceptance criteria: every alert must trigger and recover cleanly in Datadog with clear titles, tagged resources, and meaningful messages. If you have recent experience building SQL Server dashboards or monitors in Datadog, this should be straightforward. Let me know your estimated timeline and any prerequisites you’ll need from my side.
Project ID: 40775611
241 proposals
Remote project
Active 19 mins ago
Set your budget and timeframe
Get paid for your work
Outline your proposal
It's free to sign up and bid on jobs
241 freelancers are bidding on average $34 USD/hour for this job

The key is to avoid noisy static thresholds. I’ll baseline each SQL tier, group alerts by server/database/AG, and configure no-data and recovery behavior so operators receive actionable incidents rather than duplicate notifications. I’ll implement the monitors in Terraform for version control. This includes SQL integration and custom-query metrics, Error Log ingestion/facets, job duration and failure checks, AG role/synchronization health, storage/tempdb/buffer metrics, and heartbeat detection. Messages will include affected resources, likely causes, response steps, tags, and channel routing. Each monitor will be validated with a controlled trigger-and-recovery test. I’ll provide exported definitions, documented queries and variables, a threshold/response runbook, and a recorded or live handover showing test evidence. I have a few questions: Q1. How many SQL instances, AGs, and Datadog environments are in scope? Q2. Is there a non-production instance where load, job failure, AG, and offline scenarios can be tested safely? To begin, I’ll need Datadog access, host/instance tags, SQL read permissions for monitoring DMVs and msdb, and the required notification-channel details.
$40 USD in 40 days
7.8
7.8

Hello, With over a decade of experience in software development and database administration, I believe my skills make me an ideal fit for your SQL Server Datadog Alert setup. My experience includes building dashboards, monitoring performance thresholds, error occurrences, resource utilization, and database health, which aligns perfectly with the tasks you require. Apart from my extensive knowledge of Microsoft SQL Server and JSON, I am also well-versed in a wide range of programming languages that can further aid in creating custom queries and variables to suit your unique needs. Moreover, I have hands-on experience integrating AI algorithms for automation purposes - something that may come in handy when fine-tuning the alerts for maximum actionable value. Great collaboration is the key to a successful project. I can promise effective communication, meeting deadlines, and providing long-term support. To ensure a seamless hand-off process, I'll deliver comprehensive documentation along with a brief hand-over session or recording showcasing the monitors at work. Your satisfaction is my priority so let's connect and get started on building you an exceptional Datadog alert setup! Thanks!
$30 USD in 15 days
7.8
7.8

Hi, I am Elias from the sunny state of Florida. I see you need Datadog monitors configured for your SQL Server and cloud databases. The main goal here is to ensure robust monitoring that allows you to respond to potential issues proactively. The real challenge typically lies in integrating these monitors seamlessly across both environments while maintaining a clear view of performance metrics. What usually matters most here is ensuring that alerts are not only set up correctly but also tailored to your specific operational needs, minimizing false positives. My approach would involve first assessing your current database configurations and identifying key metrics that warrant monitoring. I would ensure that the alerts are structured to provide actionable insights, keeping future scalability in mind. This way, the system remains adaptable as your needs evolve. I've worked on similar setups where I configured monitoring for both on-prem and cloud databases, focusing on reliability and maintainability. A few questions to better understand the scope: Q1 – What specific metrics are most critical for your team to monitor? Q2 – Are there existing alerting thresholds you would like to replicate or adjust? Q3 – How do you currently manage alerts and incident responses? Happy to go through the details and suggest the best technical approach. Looking forward to hearing from you.
$50 USD in 5 days
7.7
7.7

Hello, We carefully studied the description of your project and we can confirm that we understand your needs and are also interested in your project. Our team has the necessary resources to start your project as soon as possible and complete it in a very short time. We are 25 years in this business and our technical specialists have strong experience in SQL, MySQL, Database Administration, Microsoft SQL Server, JSON, Documentation, Alerting, Terraform and other technologies relevant to your project. Please, review our profile https://www.freelancer.com/u/tangramua where you can find detailed information about our company, our portfolio, and the client's recent reviews. Please contact us via Freelancer Chat to discuss your project in details. Best regards, Sales department Tangram Canada Inc.
$30 USD in 5 days
7.8
7.8

YES --->> I can help configure actionable Datadog monitors for your on-prem SQL Server estate and cloud databases, with tested alerts, recovery conditions, and clear documentation. ----- I’m a passionate Full Stack Developer with skills in database monitoring, infrastructure observability, SQL performance analysis, and automation. **SKILL SET:** Datadog, SQL Server, T-SQL, Terraform, JSON, CPU & Memory Monitoring, Query Performance, SQL Error Logs, tempdb, Disk Utilization, SQL Agent Jobs, AlwaysOn Availability Groups, Alerting Integrations, and Runbook Documentation. I’ll configure and validate the monitors, ensure alerts trigger and recover correctly, and provide reusable definitions, a maintenance runbook, and a handover walkthrough. **Estimated timeline:** 3–5 business days, depending on database access and available metrics. Could you confirm whether you use Datadog’s SQL Server integration already and which alert channels (Slack, Microsoft Teams, or email) you want configured? Thanks!
$25 USD in 40 days
7.8
7.8

Reuse Datadog’s SQL Server metrics before adding custom queries; high SQL memory usage alone is normal, so alert on memory pressure rather than a flat percentage. We’ll cover CPU, memory, waits, slow queries, SQL Error Log events, disks, tempdb, buffer cache, job failures/duration, AG roles/sync, and heartbeat loss. In 4 days, we’ll deliver Terraform monitors, a threshold/response runbook documenting custom queries and variables, and a recording proving trigger/recovery using controlled tests. Resource tags, clear titles, recovery thresholds and routed messages will make alerts actionable. To start, we’ll need scoped Datadog/SQL access and a safe test target; we’ll identify minimum permissions with you. Which cloud database services are included alongside the on-prem SQL Servers? Sid Techno LLC Muhammad S.
$35 USD in 40 days
7.2
7.2

Hi, I can configure Datadog monitors for your SQL Server and cloud databases, covering performance, error logs, disk and tempdb usage, SQL Agent jobs, AlwaysOn AG health, and server availability. With 10 years of development experience, I’ll create maintainable monitor definitions, test alert and recovery scenarios, and provide a practical runbook with clear thresholds, tags, and response steps. Let’s connect to discuss your environment and monitoring requirements! Thank you Best Regards Gaurav Garg
$38 USD in 40 days
7.3
7.3

I will create robust Datadog monitors for your SQL Server and cloud databases, tailored to your specific needs. The monitors will be designed to provide actionable alerts for performance thresholds, error occurrences, resource utilization, agent job statuses, AlwaysOn AG health, and server connectivity. The deliverables will include monitor definitions, a runbook, and a hand-over session to ensure effective post-deployment management. I have the expertise to meet your requirements promptly and efficiently, setting the stage for a long-term partnership focused on enhancing your monitoring capabilities. Let's discuss your timeline and any additional information to get started.
$45 USD in 5 days
6.8
6.8

I've reviewed your requirements and understand you need actionable, reliable Datadog monitors for your on-prem and cloud SQL Server estate. Since you already have the Datadog agent running, the focus is on crafting precise monitor definitions using SQL queries to capture performance, error logs, resource usage, job status, AlwaysOn AG health, and heartbeat loss. I’ll use SQL Server T-SQL queries via Datadog’s SQL integration to pull metrics from system views like sys.dm_os_performance_counters, sys.dm_exec_requests, and SQL Server error logs. Each monitor will be tested in a controlled environment to confirm it triggers and clears correctly, with clear titles, tags, and meaningful messages. I’ll deliver JSON monitor definitions, a concise runbook explaining thresholds and response actions, and a short recording showing test alerts. While none of my portfolio projects involve SQL Server monitoring in Datadog, I’ve built complex backend systems with real-time data collection, alerting, and integration with monitoring tools, like the Binance Trading Bot and 3Commas-style platform, where automated monitoring and alerting are critical. I’ll handle everything personally and walk you through the plan in chat.
$50 USD in 10 days
6.5
6.5

With 10+ years of experience in SQL Server, MySQL, database-driven systems, and technical development, 360 Elevate can implement your SQL Server Datadog alerting setup with a strong focus on reliable monitoring and actionable alerts. We can create and validate custom Datadog queries and monitors for performance thresholds, error logs, CPU/memory/resource utilization, SQL Agent job failures, AlwaysOn AG health, and maintenance conditions. We’ll ensure thresholds and alert logic are meaningful rather than generating unnecessary noise. Deliverables can include JSON monitor exports or Terraform definitions, a clear runbook documenting metrics, thresholds, and expected responses, plus testing and handover documentation. Our 60+ member team provides expertise across databases, development, DevOps, QA, and automation, giving you a reliable implementation with maintainable monitoring for long-term use.
$41 USD in 40 days
6.7
6.7

Hi, I noticed you need actionable Datadog monitors configured for your on-premise SQL Server estate and cloud databases to track CPU/memory, tempdb/buffer pool contention, error logs, agent job failures, and AlwaysOn AG replica sync states. As a Senior SQL Server DBA and Infrastructure Specialist with 11+ years of experience, I regularly configure Datadog, Prometheus, and native SQL Server DMVs/Extended Events for production monitoring and automated alerting. How I will deliver your project: - Monitor Definitions (JSON/Terraform): Build robust Datadog monitor definitions covering performance metrics, custom SQL Error Log queries, tempdb/disk latency, job failures, and AlwaysOn AG role changes (sys.dm_hadr_availability_replica_states). - Testing & Validation: Rigorously trigger and clear each alert in a test scenario to verify tags, recovery notifications, and clear, actionable alert messages. - Runbook & Handover: Provide a concise operational runbook detailing metric thresholds, custom query logic, and runbook remediation steps, followed by a live or recorded walkthrough session. Prerequisites needed: Read-only SQL Server service account permissions (VIEW SERVER STATE), Datadog API/App keys, and test notification channels (Slack/Teams/PagerDuty). - Estimated Timeline: 2 to 3 days. Freelancer Profile: https://www.freelancer.com/u/ShafirR Best regards, Shafir Rahman Senior SQL Server DBA | Infrastructure Specialist
$50 USD in 40 days
6.7
6.7

Hi — Puru here from ErgoSphere. You're essentially setting up a comprehensive alerting system for SQL Server using Datadog, focusing on performance, resource utilization, and availability. What usually matters most here is ensuring the accuracy of alert triggers and the reliability of alert channels, as well as the maintainability of custom queries and definitions. I recommend utilizing Terraform for defining monitor configurations due to its modularity and version control advantages. For custom queries, leveraging Datadog's query language can provide precise metrics. Credentials and sensitive data should be securely handled through Datadog's built-in variables and environment secrets. I've worked on Datadog integrations, SQL performance monitoring, and Terraform-based infrastructure as code. A few questions to better understand the scope: Q1 – Do you have a preferred alert channel (e.g., Slack, email) for notifications? Q2 – Are there specific custom metrics or logs that need to be integrated beyond the standard SQL Error Log? Q3 – Can you confirm the Datadog version and any existing dashboards currently in use? A working prototype could reasonably be targeted within 2–3 weeks, followed by a polished release in roughly 4–5 weeks depending on testing and documentation needs. Looking forward to hearing from you.
$60 USD in 40 days
6.3
6.3

Hello Sir. Hope you're having a productive day! My approach is to build on your existing Datadog Agent setup rather than introduce unnecessary changes. The main areas I would focus on are: 1. Performance and resources: Monitor CPU, memory, query duration, waits, disk usage, tempdb, and buffer cache. 2. SQL Server health: Detect SQL Error Log events, failed SQL Agent jobs, long-running jobs, and AlwaysOn availability or synchronization issues. 3. Availability and alerting: Configure heartbeat and server-offline alerts with clear messages, resource tags, and recovery notifications. I would use Terraform or Datadog monitor JSON, test trigger and recovery behavior, and document thresholds, custom queries, prerequisites, and response steps in a concise runbook. I would also arrange a handover session to demonstrate the alerts and explain how your team can maintain them. A couple of questions: Are you using Datadog's SQL Server integration with custom queries enabled? Also, which notification channels do you prefer, such as Slack, Microsoft Teams, or email? Once I understand your SQL Server versions, environment, and existing metric coverage, I can provide a realistic timeline and identify any required permissions or configuration changes. Let's make your alerts useful enough to catch real problems without turning every database hiccup into an alarm! Best Regards
$40 USD in 40 days
6.3
6.3

As an Electrical Engineer, my core skills extend to encompass a range of applications, including but not limited to, data engineering for various industries. My work is centered on providing robust solutions which blend hardware and software, essential in this scenario. I am well versed in SQL and have recent experience working with Datadog, configuring monitors, and building SQL Server dashboards. Beyond working with Datadog, my specialties include firmware development and IoT product engineering, giving me an insight into practical application of data on a multitude of devices. I perform at every stage from concept to product delivery. This mastery aligns hand-in-hand with your requirement of delivering comprehensive monitor definitions, a runbook and conducting a hand-off session showing the monitors firing and recovering seamlessly. In conclusion, choosing me would mean hiring someone who is not only experienced with Datadog alert setup, but also brings an added value of understanding how your entire infrastructure functions beyond just monitoring. My dedication to seeing projects through from conception to final product coupled with my strong programming knowledge would make your transition to these monitored systems as smooth as possible. I eagerly await your reply on how we can take this project forward.
$50 USD in 40 days
6.1
6.1

Drawing from our extensive experience in MySQL and Microsoft SQL Server administration, SoftwareLinkers is the ideal choice for your SQL Server Datadog alert setup. We have successfully designed and implemented various monitoring and alert systems for clients across different industries, giving us a meticulous eye for detail and the ability to tailor solutions to specific needs. To effectively set up actionable alerts for your systems, we will pragmatically analyze your project requirements and devise efficient queries to track performance, resource utilization, error logs, agent jobs, AlwaysOn AG health, and server heartbeat. Leveraging our proficiency with Datadog, we'll craft monitors that precisely target your listed concerns delivering on the stipulated acceptance criteria. Entrusting us with your task assures you of comprehensive deliverables: a detailed definition of Datadog monitors (in JSON or Terraform format), an informative runbook enlisting all the metrics and thresholds employed, plus a monitored test scenario handover video to demonstrate each monitor's firing and successful clearance. Our commitment to long-term support ensures a seamless transition post-project completion as we will document any unique queries or variables we utilize during this process. Choose SoftwareLinkers for consistent quality-delivery paired with scalable support. Ignite efficacy into your system's monitoring; let biased-by-results select SoftwareLinkers deal-winning tech-partner
$50 USD in 40 days
6.3
6.3

Hi, I can configure Datadog monitors for your on-prem SQL Server estate and cloud databases, covering performance, SQL Error Log events, disks, tempdb, buffer cache, Agent jobs, AlwaysOn AG, and host heartbeat loss. I will create clear monitor definitions in JSON or Terraform, add useful tags and alert messages, then test both firing and recovery for every alert. My work with Microsoft systems and Database Administration includes writing reliable SQL queries and checking that thresholds are practical rather than noisy. I will also prepare the runbook and walk your team through the setup. Are your SQL Server metrics and Error Log data already available in Datadog, and should I use JSON or Terraform for the monitor definitions? Please start the chat and let’s discuss your current Datadog integration, access, and preferred export format.
$35 USD in 15 days
6.1
6.1

Hi, one thing that trips people on the SQL Error Log monitor: the ERRORLOG file is UTF-16. If the agent's log config doesn't set encoding to utf-16-le, Datadog shows garbage and the error monitors never match anything. My SQL Server side is deep. Through User Solutions I've built production scheduling systems on SQL Server that run in plants at GE, Cummins and BAE. So waits, tempdb pressure, buffer cache, blocking and Agent jobs are daily work for me. I'll be honest that I don't have a public Datadog SQL Server project to link, so I'd rather prove it on your setup first. Here's how I'd do it. I'll turn on the parts of the sqlserver integration most setups miss: AlwaysOn metrics, Agent job metrics and a custom query for long-running sessions. Then I'll write every monitor in Terraform, with clear titles, tags for host, instance and AG, and messages that say what to check first. Heartbeat loss uses the can_connect check plus a no-data rule. To test, I'll raise a logged error, fail a test job, fill a test tempdb and do a planned AG failover on a test replica, never on prod. I'll start with the heartbeat and error log monitors so you can watch them fire and clear before I do the rest. Full set, runbook and recorded handover in about 10 days. From you I'll need a Datadog API and app key, a SQL login with VIEW SERVER STATE and msdb read, a test instance with an AG, and your alert channels. Are the cloud databases on Azure SQL, RDS or something else? Haleem
$25 USD in 40 days
5.8
5.8

Hello, DATADOG SQL SERVER MONITORING — ACTIONABLE ALERTS & AUTOMATED RECOVERY TESTING I HAVE EXPERIENCE WITH SIMILAR MONITORING AND INFRASTRUCTURE TASKS AND CAN DISCUSS RELEVANT WORK. I have 12 years of experience in IT development and can configure Datadog monitors for your on-prem SQL Server estate and cloud databases using monitor queries, JSON definitions, or Terraform. I will cover CPU, memory, waits, long-running queries, SQL Error Logs, disk and tempdb usage, buffer cache, SQL Agent job failures, AlwaysOn AG health, replica synchronization, and server heartbeat loss. I will configure meaningful alert messages, resource tags, notification channels, and recovery thresholds. I will test alert and recovery behaviour, document custom queries and thresholds, and provide a maintenance runbook with a handover session. Lets Connect and discuss project in detail with an opportunity to start work together... Thanks, Christina
$25 USD in 40 days
5.7
5.7

Hello, I'm Denis, a full-stack developer, and I have built monitoring systems for SQL Server environments that catch problems before they affect users. You need comprehensive Datadog alerts across your SQL Server estate so your team gets notified when performance degrades, jobs fail, or availability changes. Right now the agent is running but you lack the queries and monitor definitions to actually catch the issues that matter, which means problems slip through undetected. I would start by reviewing your current SQL Server setup and Datadog agent configuration to understand your environment. Then I would build custom queries to pull performance metrics, error logs, and job data, create the monitor definitions in Terraform for version control, and test each one to confirm it fires and clears correctly. Finally, I would document the thresholds and expected responses in a runbook and walk you through a test scenario so your team knows how to respond to each alert type. The key challenge is setting thresholds that actually matter. Too low and your team gets alert fatigue; too high and problems go unnoticed. I would start with industry baselines for your workload, then adjust based on your normal operating ranges. A realistic risk is that some custom queries may need tuning once they run against your live data, so I would build them to be easy to adjust after hand-off. I can start working right away. Let's connect and discuss the details. Thanks, Denis.
$25 USD in 40 days
5.4
5.4

Hello, I have a background in software development, SQL databases, API integration, testing, and technical documentation. My experience with Java, Spring Boot, MySQL, and structured data processing has given me a solid foundation for working with database-driven systems. For your Datadog monitoring setup, I would take a structured approach: 1. Review the existing Datadog Agent configuration, SQL Server integration, database access, and available metrics. 2. Configure and organize monitors for performance, errors, resource utilization, SQL Agent jobs, AlwaysOn AG health, and server availability. 3. Define meaningful thresholds, resource tags, alert messages, and notification channels based on your operational requirements. 4. Test alert and recovery behavior using safe, agreed-upon test scenarios. 5. Export the monitor definitions and document custom queries, thresholds, prerequisites, and troubleshooting steps for future maintenance. I would begin by reviewing the current environment and confirming which metrics and permissions are available, particularly for SQL Server Error Logs and AlwaysOn AG monitoring. My strengths in development, testing, and documentation would help me approach the setup methodically and deliver maintainable configurations. I would be happy to discuss the existing environment and agree on a practical implementation scope and timeline. Best regards, Somee
$25 USD in 40 days
5.5
5.5

Orem, United States
Payment method verified
Member since Sep 2, 2021
$50 USD
$25-50 USD / hour
$15-25 USD / hour
$15-25 USD / hour
$30-250 USD
$250-750 AUD
$250-750 USD
$15-25 USD / hour
$115-200 HKD / hour
₹600-1500 INR
$25-50 USD / hour
£750-1500 GBP
$1500-3000 USD
$25-50 USD / hour
₹12500-37500 INR
£10-20 GBP
$30-250 USD
$250-750 USD
$25-50 USD / hour
$15-18 USD / hour
$30-250 USD