Monitor và optimize SQL Server database performance from any device.

Bạn đang xem: Download sql server 2014 sinhvienit, hướng dẫn cài đặt sql enterprise 2012 full

Spotlight® on Squốc lộ Server Enterprise delivers simplithành phố withoutcompromiseby providing unmatched SQL Server monitoring, diagnosis & optimizationof your database environment to ensure peak performance around the clock.
*

*
01:58
SQL Server environments are becoming more complex while remaining a criticalcomponent of your application architecture. It’s a struggle to keep upwith this continual growth without the right SQL monitoring tools. What if youcould proactively manage your SQL Server environment và diagnose databaseperformance issues by viewing the health of all your Squốc lộ Server instances on asingle screen, anytime, anywhere on any device? You can with the right SQLServer monitoring tool.

With Spotlight on Squốc lộ Server Enterprise, you can manage yourSquốc lộ Serverenvironment while also gaining visibility inlớn your operating system –Windows or Linux – and also monitor your virtualization infrastructure.Make configuration a breeze with templates, automated alerts and customizableactions. Spkết thúc less time fighting fires by accurately diagnosing real-time andhistorical database performance issues, and focus on more proactive measureslượt thích query tuning.


Key benefits


Simpliđô thị without compromise
Quick installation and simple configuration let you start monitoring environments immediately.
End-to-kết thúc monitoring
Get a complete picture of everything that affects your SQL Server performance
Smartphone capability
Intuitive overviews & thiết bị di động device support deliver the data you need where and when you need it.

Features


24x7 monitoring và diagnostics
Agentless monitoring from a centralized diagnostic hệ thống with alarms for performance deviations
Powerful root cause analysis
Create multiple diagnostic workflows, including detailed workload analysis and deadlochồng detection
Incident playback
Rewind dashboards & diagnostic drilldowns to incident occurrence & review it in slow motion
SQL analysis and Xpert tuning
Squốc lộ Optimizer integration highlights long-running queries và sub-optimal code for further tuning
Health check và intelligence
Obtain a holistic view of the health of your system & benchmark results with other users
Customize for your environment
Set custom thresholds, create counters và establish rule-based actions on a one-time or recurring basis

Tour


PreviousNext
Prioritize at a Glance
Intuitive Dashboards
Monitor and diagnose
Never Miss a Beat
Wait Stat Analysis
Workload Analysis
Replication Dashboard
Analysis Services
*

Prioritize at a Glance


Our Heatmap prioritizes at a glance across all monitored instances.
*

Intuitive Dashboards


Follow indicators on context-specific dashboards lớn the problem source.
*

Monitor and diagnose


Operating system diagnostics with SQL Server VNext on Linux

Never Miss a Beat


Instantly respond lớn issues with native sầu apps for your sản phẩm điện thoại device.

Wait Stat Analysis


Quickly identify what is waiting on resources right down to lớn Squốc lộ statements.

Workload Analysis


Divide workload by host, database, user or Squốc lộ statement in a few clicks.

Replication Dashboard


Watch for any failures or bottlenecks across your replication topology.

Analysis Services


Monitor instances from the Spotlight dashboard and diagnostic drilldowns.

Specifications


Spotlight client
Before installing the Spotlight client, ensure your system meets thefollowing minimum hardware & software requirements:

Platform

1GHz Processor

Memory

1GB RAM recommended

Hard disk space

200MB

This space should exist on a local disk drive sầu rather than a networkdrive

Operating system
Microsoft Windows 10 (32-bit & 64-bit)Microsoft Windows 8.1 (32-bit và 64-bit)Microsoft Windows 8 (32-bit và 64-bit)Microsoft Windows 7 (32-bit & 64-bit)
Microsoft Windows Server 2012 R2 (64-bit)Microsoft Windows Server 2012 (64-bit)Microsoft Windows Server 2008 R2 (64-bit)Microsoft Windows Server 2008 (32-bit and 64-bit)
Additional software

Squốc lộ Server Client Tools

To use the Discovery Wizard to lớn locate Squốc lộ Servers on yournetwork, the Squốc lộ Server Client Tools must be installed on theSpotlight client. The Squốc lộ Server Client Tools can be found on theinstallation disk for Microsoft Squốc lộ Server 2000, 2005 or 2008.

Install .NET 2.0 or later

To use the Spotlight Report Viewer, .NET 2.0 or later must beinstalled on the Spotlight client machine.Microsoft Internet Explorer 6.0 or later.
Other requirements
CD-ROM drive sầu or mạng internet connection (required for installationonly).A monitor capable of supporting a resolution of 1280x1024 orgreater
Diagnostic Server

Before installing the Diagnostic Server, ensure your system meets thefollowing minimum hardware và software requirements:

Platform

2GHz Dual bộ vi xử lý Core Processor

Memory

300MB

Hard disk space

4GB RAM

If the Diagnostic Server’s connection to the SpotlightStatistics Repository or playbaông xã database is interrupted, theDiagnostic Server will cabịt data khổng lồ the local disk. In this event, anextra 2MB per hour, per monitored VPS is required.

Operating system
Microsoft Windows 10 (32-bit and 64-bit)Microsoft Windows 8.1 (32-bit & 64-bit)Microsoft Windows 8 (32-bit and 64-bit)Microsoft Windows 7 (32-bit & 64-bit)
Microsoft Windows Server 2012 R2 (64-bit)Microsoft Windows Server 2012 (64-bit)Microsoft Windows Server 2008 R2 (64-bit)Microsoft Windows Server 2008 (32-bit & 64-bit)
Additional software
.NET 3.5 or later must be installed on the Diagnostic Servermachine.

SQL Server Client Tools

To use the Discovery Wizard to lớn locate SQL Servers on yournetwork, the Squốc lộ Server Client Tools must be installed on theDiagnostic Server. The SQL Server Client Tools are on theinstallation disk for Microsoft SQL Server 2000, 2005 and 2008.To use Spotlight on Analysis Services, the Client Connectivitytools must be installed.

SQL Server Management Tools

To use Spotlight on Analysis Services, Spotlight on SQL ServerReplication, và Session Trace & SQL Analysis in Spotlight on SQLServer, Squốc lộ Server Management Tools must be installed on theDiagnostic Server.The SQL Server Management Tools are available from any SQL Server2005 or SQL Server 2008 edition except Squốc lộ Server Express và SQLServer Compact. The version required corresponds lớn the latestversion of Squốc lộ Server that you are monitoring. lưu ý, if you aremonitoring SQL Server 2000 servers, you need the Management Toolsfrom SQL Server 2005.
Monitoring
Squốc lộ Server

Spotlight can diagnose Squốc lộ Server instances of the followingversions:


SQL Server 2005 through 2017

Spotlight on SQL Server also supports MSDE (2000), SQL Express (2005)& SQL Server 2008 Express Edition và SQL Server 2012 Express. Notethat use of these versions to host playbachồng or Spotlight StatisticsRepository databases is not supported.

Xem thêm: Hello Mr - Download Aoe 1

Spotlight cannot diagnose earlier versions of Squốc lộ Server (version 7.xand earlier).

Spotlight supports all SQL Server sort orders, includingcase-sensitive và binary sort orders. Spotlight cannot connect lớn SQLServer instances where the instance name contains non-US ASCIIcharacters.

Operating system

Spotlight on SQL Server can monitor virtual guest machines in aVMware ESX infrastructure. The following versions are supported:


VMware vCenter 2.5 (or later)VMware ESX Server 4.0 (or later)Microsoft Windows Server 2012 R2 (64-bit)
Microsoft Windows Server 2012 (64-bit)Microsoft Windows Server 2008 R2 (64-bit)Microsoft Windows Server 2008 (32-bit và 64-bit)

Note: On each monitored instance, Spotlight requires the networksetting "File và Print Sharing" to lớn be enabled & any firewall to beconfigured to:

open port 1434 for UDPhường packetsopen the Squốc lộ Server TCP.. port (mặc định is 1433)Virtualization

Spotlight on SQL Server can monitor virtual guest machines in aVMware ESX infrastructure. The following versions are supported:


VMware vCenter 2.5 (or later)
VMware ESX Server 4.0 (or later)

Spotlight on Squốc lộ Server can monitor virtual machines in aHyper-V® infrastructure. Spotlight supports

Hyper-V® 6.2 và above.
Spotlight Statistics Repository

Before installing the Spotlight Statistics Repository, ensure yoursystem meets the following minimum requirements:

Database sizing

By default, the kích thước of the Spotlight Statistics Repository is phối to1000MB (data size) and 250MB (log size). These sizes are flexible andcan be changed by running the Spotlight Statistics Repository creationscript.

The script is located in the install directory as follows:

..Plug-insDiagnostics ServerScriptsHard disk space

Approximately 1.2GB for each monitored Squốc lộ Server instance và thecorresponding monitored Windows host on which the Squốc lộ Server instanceresides. This estimate assumes default configuration in an averageenvironment. Actual space used will depkết thúc on your environment and anydata collection/storage configuration changes that are made. For moreinformation, see the Spotlight on SQL Server Sizing Wizard. You canaccess the wizard from the Spotlight Installation Center. To useSpotlight Reporting and Trending, it is recommended that the SpotlightStatistics Repository is installed on Squốc lộ Server 2005, Squốc lộ Server 2008,Squốc lộ Server 2008 R2 or SQL Server 2012.

Recommended Squốc lộ Server version

Installing the Spotlight Statistics Repository on SQL Server 2000 canresult in errors being displayed và no data being shown in some views.Installing the Spotlight Statistics Repository on Squốc lộ Server 2000 isnot recommended.

Note: Due to lớn the kích thước of the Spotlight StatisticsRepository, it is recommended that this database is not installed on aSQL Express instance.

Other requirements

The Squốc lộ Browser service must be running on the machine where theSpotlight Statistics Repository is installed. Alternatively you can usethe host và port number of the (named) SQL Server instance you want toconnect lớn, when creating a connection and connecting to the SpotlightStatistics Repository.

The TCPhường protocol must be enabled on the instance where the SpotlightStatistics Repository resides.

For more information, see the Spotlight on Squốc lộ Server DeploymentGuide.

Maintenance

It is highly recommended that regular maintenance is performed on theSpotlight Statistics Repository. The recommended maintenance plan isoutlined in the online help & in the Spotlight on SQL ServerDeployment Guide.


Before installing the playback database, ensure your system meets thefollowing minimum requirements:

Database sizing

By mặc định, the size of the playbaông xã database is phối lớn 500MB (datasize) & 125MB (log size).

Hard disk space

Requires approximately 270MB for each monitored Squốc lộ Server instanceand the corresponding monitored Windows host on which the Squốc lộ Serverinstance resides.

Assumes mặc định configuration in an average environment. Actual spaceused will depover on your environment & any data collection/storageconfiguration changes that are made.

For more information see the Spotlight on SQL Server Sizing Wizard,you can access the wizard from the Spotlight Installation Center.

Recommended SQL Server version

Due lớn the kích cỡ of the playbaông chồng database, it is recommended that thisdatabase is not installed on a SQL Express instance.

Other requirements

The Squốc lộ Browser service must be running on the machine where theplaybaông xã database is installed. Alternatively you can use the host andport number of the (named) SQL Server instance you want to lớn connect lớn,when creating a connection & connecting to the playbaông chồng database.

The TCP protocol must be enabled on the instance where the playbackdatabase resides.

For more information, see the Spotlight on SQL Server DeploymentGuide

Maintenance

It is highly recommended that regular maintenance is performed on theplaybaông chồng database. The recommended maintenance plan is outlined in theonline help và in the Spotlight on Squốc lộ Server Deployment Guide.

Bài viết liên quan

Trả lời

Email của bạn sẽ không được hiển thị công khai. Các trường bắt buộc được đánh dấu *