1. Can I install SQL Server on Linux and UNIX platforms ?
2. Comparison between Oracle and Microsoft SQL Server ?
2. Comparison between Oracle and Microsoft SQL Server ?
Define Some DB Server tools of SQL server:
Profiler, DTA, SSMS, SAC, SSCM, PerfMon, DMVs, System procs
Profiler
SQL Server Profiler can perform various significant functions such as tracing what is running under the SQL Server Engine's hood, and finding out how queries are resolved internally and what scripts are running to accomplish any T-SQL command. The major functions this tool can perform have been listed below:
SQL Server Profiler can perform various significant functions such as tracing what is running under the SQL Server Engine's hood, and finding out how queries are resolved internally and what scripts are running to accomplish any T-SQL command. The major functions this tool can perform have been listed below:
- Creating trace
- Watching trace
- Storing trace
- Replaying trace
Trace includes all the T-SQL scripts that run simultaneously on SQL Server. As trace contains all the T-SQL scripts running on SQL Server, it often tends to become considerably huge. Hence, it is always a good practice to capture only those data that are actually required for analysis.
DTA - Database Tuning Advisor
In SQL Server, The DTA utility is the command prompt version of Database Engine Tuning Advisor. The DTA utility is designed to allow you to use Database Engine Tuning Advisor functionality in applications and scripts.
Like Database Engine Tuning Advisor, the DTA utility analyzes a workload and recommends physical design structures to improve server performance for that workload. The workload can be a plan cache, a SQL Server Profiler trace file or table, or a Transact-SQL script. Physical design structures include indexes, indexed views, and partitioning. After analyzing a workload, the DTA utility produces a recommendation for the physical design of databases and can generate the necessary script to implement the recommendation. Workloads can be specified from the command prompt with the -if or the -it argument. You can also specify an XML input file from the command prompt with the -ix argument. In that case, the workload is specified in the XML input file.
SSMS - SQL Server Management Studio
SSMS is a comprehensive utility for managing SQL Server objects that combines an easy-to-use graphical interface with rich scripting capabilities. Management Studio can be used to manage Database Engine, Analysis Services, Integration Services, and Reporting Services.
SAC - Surface Area Configuration
In the default configuration of new installations of SQL Server, many features are not enabled. SQL Server selectively installs and starts only key services and features, to minimize the number of features that can be attacked by a malicious user. A system administrator can change these defaults at installation time and also selectively enable or disable features of a running instance of SQL Server. Additionally, some components may not be available when connecting from other computers until protocols are configured.
In Microsoft SQL Server, there are a number of services, ports, and connections that can be configured to control how much “surface area” is exposed. For instance, the SQL Server Surface Area Configuration tool allows administrators to control connection access as Local connections only, or Local and Remote connections.
SSCM - SQL Server Configuration Manager
SSCM is a tool to manage the services associated with SQL Server, to configure the network protocols used by SQL Server, and to manage the network connectivity configuration from SQL Server client computers. SQL Server Configuration Manager is a Microsoft Management Console snap-in that is available from the Start menu, or can be added to any other Microsoft Management Console display. Microsoft Management Console (mmc.exe) uses the SQLServerManager10.msc file in the Windows System32 folder to open SQL Server Configuration Manager.
PerfMon - Performance Monitor
Perfmon measures performance statistics on a regular interval, and saves those stats in a file. The database administrator picks the time interval, file format, and which statistics are monitored. After the stats are gathered over a period of time (hours or days), we can do analysis by opening the results in Excel and setting up some basic formulas.
Perfmon is not just for SQL Server tuning; system administrators use it to monitor performance on Windows itself, Exchange, file & print servers, and anything else that can run into bottlenecks. As a result, it is easy to find Perfmon information online, but it's not always specific to SQL Server. Since every application has its own set of statistics, it helps to get SQL-related tips.
DMVs - Dynamic management views
DMVs and functions return server state information that can be used to monitor the health of a server instance, diagnose problems, and tune performance.
Using DMVs, metadata could be exposed regarding the connections, sessions, transactions, statements and processes, which are, or have been, executing against a database instance.
System procs - System stored Procedures
Many administrative and informational activities can be performed by using system stored procedures, in SQL server.
Helpful links -
