如需獲得最佳網頁瀏覽體驗,請使用 IE 11 或更高版本、Chrome、Firefox 或 Safari。
video 01:03

SQL工具可以帮助您提高工作效率,降低成本,并保护您的数据。 但是,并非所有SQL软件都提供改进SQL Server管理所需的功能。 长远来看,使用原生SQL工具或功能欠佳的解决方案实际上具有更高的成本。

如果您可以利用功能强大的SQL软件来轻松节省时间并降低风险,会怎么样? 这可能意味着您可以提高数据库管理员的工作效率,同时避免代价高昂的停机时间。 利用我们的SQL Server工具,您可以使数据库管理员将工作负载降低多达80 %,并使他们专注于为您的业务增加价值。 借助我们业界卓越的SQL Server软件解决方案,您可以:

  • 简化性能管理
  • 加快备份和恢复
  • 集中进行管理
  • 管理和监控单个和多个数据库平台
  • 支持CI/CD作为DevOps的一部分
  • 促进团队之间的协作
  • 确保您的SQL Server环境正常运行,得到有效支持且安全无虞

功能

监控和诊断内部部署环境和Azure中的单个及多个数据库平台,促进团队间的协作,简化性能管理,保护数据,集中进行管理,以及改进SQL Server运行状况。 从Quest那里可以轻松获得合适的解决方案。
SQL Server性能监控

SQL Server性能监控

借助Spotlight on SQL Server Enterprise轻松进行优化和调整。 利用卓越的监控、诊断和优化,确保出色的性能。 获取对您所需详细信息的访问权限,以实现出色的SQL Server适用性。 获得直观的运行状况和性能概述、自动化警报和操作,以及移动设备支持。

  • 24x7的SQL Server监控与诊断
  • 功能强大的根本原因分析功能
  • 端到端监控
  • 多维分析
  • SQL分析和Xpert调整
  • 系统运行状况检查和集体智慧
阅读数据表: Spotlight on SQL Server Enterprise
阅读案例分析: Jenkon将移动数据库备份的速度加快90 %,并优化SQL查询
阅读技术简报: SQL Server on Linux: Why You'll Love It and How to Get Started
Azure托管的SQL Server性能监控

Azure托管的SQL Server性能监控

Spotlight Cloud for SQL Server是采用云技术的SQL Server性能监控解决方案,提供24x7监控、即时诊断和功能强大的调整,确保一致的性能和高可用性。 由于Spotlight Cloud是SaaS产品,因此可降低拥有成本并简化部署和维护,使任何规模的企业以及任何技能水平的数据库管理员都可以进行高端性能调整。

  • 24x7操作监控
  • 200多种SQL Server警报类型
  • 多维工作负载分析
  • 深入分析以确定警报根本原因
  • 阻止分析
  • 具有背景和建议的智能警报
  • 多达12个月的历史数据
SQL Server见解

SQL Server见解

使用Foglight轻松监控复杂且多样化的数据库环境。 了解所有涉及数据库资源、工作负载分析和更改跟踪的领域,获得宝贵的洞察力。 全面了解多平台环境(包括开源和NoSQL),以便在团队间展开协作,从而提前发现并修复会对数据库带来风险的性能问题。

  • 24x7操作监控
  • 内置的智能功能
  • 多维工作负载分析
  • 深入分析以确定警报根本原因
  • 自适应基准
  • 自动化变更跟踪
  • 历史锁定分析
阅读数据表: Foglight for SQL Server
观看视频: Foglight for SQL Server Overview
阅读技术简报: SQL性能调查分析功能
SQL Server数据库管理

SQL Server数据库管理

大幅提高数据库管理员的工作效率,确保出色的数据库性能并降低变更风险。 Toad for SQL ServerApexSQL数据库管理工具提供业界卓越的功能和直观的工作流,可轻松管理更多数据库。

  • SQL Server审核与合规性
  • SQL和脚本组执行
  • 比较和同步
  • 事务日志读取和恢复
  • SQL优化
  • 性能测试
  • 数据建模
  • 自动执行任务
阅读数据表: Toad for SQL Server
阅读技术简报: SQL Server for the Oracle DBA
阅读技术简报: Solving the SQL Tuning Problem: Secrets of Quest SQL Optimizer
SQL Server备份�����恢复

SQL Server备份和恢复

与竞争对手解决方案相比,使用LiteSpeed可节省高达85 %的备份大小和保留时间。 我们提供各种恢复选择,以针对SQL Server数据库实现高速、存储高效的备份和恢复。 确保尽快还原正确的SQL Server数据,并使数据尽快可用。

  • 加快SQL Server备份与还原的速度
  • 更加轻松地管理SQL Server
  • 简化还原
  • 目标数据和对象恢复
  • 将备份存储和速度改进多达85 %
  • 从Azure、IBM TSM和其他产品中直接集成
阅读数据表: LiteSpeed for SQL Server
观看视频: LiteSpeed for SQL Server提供高速备份、压缩和恢复
阅读技术简报: Top 8 LiteSpeed Features DBAs Should Know About
SQL Server部署、持续集成和持续部署

SQL Server部署、持续集成和持续部署

更加快速地交付应用程序并缩短数据库开发周期,而且不会影响质量或增加风险。 通过在应用程序流程中包含自动化数据库开发任务,利用CI和CD的优势。 借助适用于SQL Server的开发人员工具,您不必在速度、质量、性能和可靠性之间作出取舍。

  • 生成综合测试数据
  • 添加数据更改审核跟踪
  • 创建数据同步脚本
  • 插入常用的构建服务器
  • 自动运行SQL单元测试
  • 创建模式同步脚本
  • 编排多个步骤并从源控制进行构建

屡获殊荣的数据库管理解决方案

屡获殊荣的数据库管理解决方案

荣获2019年DBTA读者选择奖“最佳数据库开发解决方案”。

资源

针对优化SQL Server管理的数据库管理员基本手册
电子书
针对优化SQL Server管理的数据库管理员基本手册
针对优化SQL Server管理的数据库管理员基本手册
针对优化SQL Server管理的数据库管理员基本手册
阅读电子书
Jenkon moves database backups 90 percent faster, optimizes SQL queries
案例分析
Jenkon moves database backups 90 percent faster, optimizes SQL queries
Jenkon moves database backups 90 percent faster, optimizes SQL queries
Facing tremendous growth and new market opportunities, Jenkon needed new tools to monitor performance and ensure quick backups for its customers’ SQL Server databases.
阅读案例分析
The Essential DBA Playbook for Optimized SQL Server Management
电子书
The Essential DBA Playbook for Optimized SQL Server Management
The Essential DBA Playbook for Optimized SQL Server Management
Discover the essentials of optimizing SQL Server management in your organization. Read our e-book to learn how successful DBAs optimize their SQL Server environment.
阅读电子书
Bridge the Divide Between Infrastructure and Databases with Foglight®
在线活动
Bridge the Divide Between Infrastructure and Databases with Foglight®
Bridge the Divide Between Infrastructure and Databases with Foglight®
It’s the age old problem – is it the software or the infrastructure? A user calls for help – the application is slow, but what’s causing it? As a system administrator, you need to determine whether it’s the virtual machine, the code or maybe it’s the database. It could be one or more, but how do you know which one? 

Your first inclination might be to call the DBA and get them to rule out the database as the source while you investigate the VM. But what if you could immediately pinpoint the root cause anywhere in the stack and work collaboratively with your DBA to resolve it?

Currently, DBAs and system administrators are on different ends of the same problem, and neither has visibility into the other’s domain. There’s a divide between infrastructure and databases that neither side can currently bridge. 

In this program, Martin Wild will examine two common use cases that illustrate this gap and how Foglight can help bridge the divide. 

Martin will look at a situation where the database is slow because the VM is starved of resources. He will also walk through a scenario where the VM has abundant resources and those resources are then reallocated without affecting the database performance. 

In each case, he’ll show how Foglight can quickly bring the two teams together to improve system performance, reduce costs and enhance collaboration. 


参加活动
Colma il divario tra l'infrastruttura e i database con Foglight®
在线活动
Colma il divario tra l'infrastruttura e i database con Foglight®
Colma il divario tra l'infrastruttura e i database con Foglight®
Il problema è sempre lo stesso: software o infrastruttura? Un utente chiede aiuto: l'applicazione è lenta, ma perché? Come amministratore di sistema, devi determinare se è a causa della macchina virtuale, del codice o persino del database. I motivi possono essere diversi, ma come puoi saperli? 

Se invece sei un DBA, ti ritroverai a gestire problemi di prestazioni legati a doppio filo alle allocazioni di risorse di storage, memoria e I/O. Naturalmente prenderai sempre più risorse per le macchine virtuali, ma se non ne avessi davvero bisogno e fosse possibile eseguirle con meno sforzi?

DBA e amministratori di sistemi si trovano a fronteggiare da lati diversi lo stesso problema e nessuno sa cosa fa l'altro. Esiste un divario tra infrastrutture e database che nessuna delle parti, al momento, sa colmare. 

In questo programma, Alessandro Falchetti  esaminerà due casi d'uso comuni che illustrano questo divario e spiegherà come Foglight può aiutare a colmarlo. 

Alessandro analizzerà una situazione di database lento a causa delle poche risorse disponibili alla macchina virtuale. Parlerà inoltre di uno scenario in cui la macchina aveva molte risorse, riallocate in seguito senza influire negativamente sulle prestazioni del database. In ciascun caso, mostrerà come Foglight può riunire rapidamente i due team migliorando prestazioni di sistema, riducendo i costi e rafforzando la collaborazione. 
参加活动
Salve el abismo entre la infraestructura y las bases de datos con Foglight®
在线活动
Salve el abismo entre la infraestructura y las bases de datos con Foglight®
Salve el abismo entre la infraestructura y las bases de datos con Foglight®
Es el problema de siempre: ¿se trata del software o de la infraestructura? Un usuario llama pidiendo ayuda porque la aplicación va lenta, ¿pero cuál es el motivo? Como administrador de sistemas, debe determinar si se trata de la máquina virtual, del código o quizá de la base de datos. Podría ser uno o más de estos elementos, ¿pero cómo sabe de cuál se trata? 

Entretanto, si administra bases de datos, le tocará lidiar con problemas de rendimiento vinculados directamente con las asignaciones de recursos de almacenamiento, memoria y E/S. Por supuesto, siempre reservará más recursos para las máquinas virtuales, pero ¿y si, en realidad, no los necesitara y pudiera ejecutarlas de forma más eficiente con menos?

Los administradores de sistemas y los de bases de datos trabajan en facetas distintas del mismo problema, y ninguno de ellos puede ver el dominio de la otra parte. Existe un abismo entre el lado de la infraestructura y el de las bases de datos que, actualmente, ninguno de ellos puede salvar. 

En este programa, Alessandro Falchetti examinará dos casos prácticos frecuentes que ilustran este abismo y cómo puede ayudarle Foglight a salvarlo. 

Alessandro analizará una situación en la que la base de datos funciona lentamente porque la máquina virtual está famélica de recursos. Asimismo, repasará una situación en la que la máquina virtual dispone de recursos en abundancia que luego se reasignan sin afectar al rendimiento de la base de datos. En cada caso, mostrará cómo puede Foglight juntar rápidamente a ambos equipos para mejorar el rendimiento del sistema, reducir los costes y mejorar la colaboración. 
参加活动
Managing Your eCommerce Site to Prevent Downtime and Increase Your Speed to Resolution
在线活动
Managing Your eCommerce Site to Prevent Downtime and Increase Your Speed to Resolution
Managing Your eCommerce Site to Prevent Downtime and Increase Your Speed to Resolution

As eCommerce has become more critical for revenue generation, your database teams face the unique challenge of monitoring heterogeneous environments while also managing database performance and uptime.  Learn how to prevent outages and increase your speed to resolve database performance problems.

Join us for a LIVE webinar where our expert, Janis Griffin, will cover how Quest’s Foglight for Databases can:

Isolate database performance issues and reduce resolution time for mission-critical applications

  • Deploy across complex and unique environments and architectures
  • Handle databases in different locations (including on-premises and cloud)
  • Support new database platforms and new cloud database service technologies
参加活动
Ask the Experts: Database Performance Roundtable
在线活动
Ask the Experts: Database Performance Roundtable
Ask the Experts: Database Performance Roundtable

Join Quest for this live streaming event, featuring Brent Ozar and Pinal Dave

Hold on to your hats as two powerhouses of the SQL Server world come together on one virtual stage to answer your top database performance questions. Anything could happen! These two are:

  • The Fred and George Weasley of the database wizarding world, always ready with a quip, explosion or skiving snackbox…
  • The Kirk and Spock of the SQL Server universe, ready to boldly go where no one has gone before…
  • The Batman and Robin of performance tuning, with an endless utility belt of database tools…

You get the picture.

Don’t miss this one-of-a-kind opportunity to get advice and real-world insight from industry-leading experts, Brent Ozar, Microsoft Certified Master and Pinal Dave, SQL Server Performance Tuning Expert.

Register to attend and be sure to submit your questions for our virtual Q&A. Hurry, space is limited and will fill up quickly.

参加活动

立即行动

已准备好使SQL Server纳入掌控之下?