遍尋不著 SQL 2005 SqlDiag 工具程式的相關說明,只有一份韓國微軟的 PPT 看來還可用(http://download.microsoft.com/download/c/4/0/c40eec0a-c937-448d-a430-9643824fa713/1123_T1_S6.ppt),透過 Google 的韓文翻譯英文,然後猜天書吧(若再把它從英文翻成繁體中文,就更有加密的效果了)…
 
 SQL Server 2005 where it uses SQLDiag  
Efficiency diagnosis
Kim kind nine division chiefs (jkkim@microsoft.com)
With Korean microphone soft
 
 
SQLDiag is?
SQL Server 2005 diagnosis data acquisition services
PSSDiag tool chests with SQLDiag name fringe land.
It substitutes with the name whose SQLDiag where it is used from SS2K/7.0 is identical.
SQL the tool it will be able to collect all diagnosis data about Server relation issues in once
 
 
History
It draws up in 2001.
From inside the customer technical support department it was used in majority of SQL Server relation cases.
Tech support Edo use of different product. (Exchange backs)
It opens to the public to the public at 2003.
SQL from Server 2005 in server the internal organs.
SQL from from Server 2005 the tech support start against SQLDiag.
 
 
SQLDiag will be able to collect? 
Profiler trace
Blocking script/trace
Perfmon/Sysmon logs
Server configuration and state info
SQL Server error logs
Event logs
MSInfo
Virtually any other diagnostic
 
 
Service vs. Console App
Two branch multi operation possibility.
The case unmanned operational possibility which will be operated with service.
It records in log file and event log.
Supports self-registration/deregistration (/R, /U)
Supports service control (START, STOP and STOP_ABORT)
 
 
Start and middle finger
Console app
Run SQLDiag.exe to start it
Press Ctrl+C to stop it or create “stop file”
Press Ctrl+C a second time to stop ASAP
Service
SQLDIAG START to start it
SQLDIAG STOP to stop it
SQLDIAG STOP_ABORT to stop ASAP
 
 
Configuration file
XML and INI format supports
/I option it leads, designation
text with editor B GUI configuration app set possibility
 
 
Configuration file
From SQLDiag 3 branch default file provision:
SQLDiag.XML (default) – snapshot of error logs, configuration and state info and MSInfo
SD_General.XML – lightweight version of all diagnostics – Profiler, Perfmon and event logs and etc.
SD_Detailed.XML – heavier version of all diagnostics (stmt-level Trace events)
 
 
Objective machine and Instance
It designates from configuration file.
Basic price currently from all Instance of machines data collection
Specific machine or Instance designation possibility
 
 
Security
SQL about member of Server sysadmin groups Oh! box.
Login must be possible in the object Instance.
About member of Administrators groups Oh! box.
 
    When /G (Generic mode) to the case which is 3 bays it is sufficient.
 
 
Output
Basic output folder… 90 Tools Binn SQLDiag
/O it leads, fringe land possibility
Profiler and Perfmon rollover supports
While data acquisition /C1 option NTFS compressive possibilities about under using
 
 
Output 
The folder will become the name fringe land with automatic, or, it will cover, the possibility writing it was. (/N)
Profiler trace after being recorded in Log folder of server, movement.
Output file names machines and Instance names inclusion
Internal output file “have ##” prefix
 
 
Scheduling
/B option it leads beginning time set:
   SQLDIAG /B 20050819_11: 00: 00
Before the beginning time becomes by, CPU it does not use.
/E option it leads, middle finger timely set:
SQLDIAG /E 20050819_13: 00: 00
Regarding a start and the middle finger relative timely set possibility:
    SQLDIAG /B +02: 00: 00 /E +01: 00: 00
– It starts in 2 hour after, during 1 hour end after data acquisition
 
 
Scheduling 
/X option about under using corresponding point of view (snapshot) after data acquisition middle finger
/L option about under using with automatic after the middle finger which becomes schedule re-start
SQLAgent tube printed style of writing Scheduling possibility
 
 
Data acquisition of long period
With service execution about under registering
Target data collection hazard schedule use
Output folder renaming and auto-restart uses
.TRC and the hazard /C1 option use consideration which economizes the space where it is caused by with rolled over of .BLG file fields
 
 
Clusters
Against a lower part fact about all virtual server data with automatic extraction:
With objective server name “.”This the case which is set (default)
Becomes the accomplishment from Cluster, node the case where
/G (generic mode) the case which is not set (default)
It confirms Cluster virtual servers, about all Instance of each virtual server a data it collects.
 
 
Remote Machines
Recommend approach is to install the service on remote machines
SQLDiag regarding a remote server data acquisition possibility
TRC files come to move after being stored in corresponding server.
Different data in the machine where SQLDiag is accomplished store
 
 
Multiple Machines
Section against each machine in configuration file addition
All the data which is collected is together stored with output folder.
Each machine is allocated each Cabinet conference worker thread.
All efficiency log in low my BLG files south chaff burden.
 
 
Custom Tasks
Supports wide variety of custom tasks:
TSQL command
TSQL script (with parameters)
Registry query and backup
Copy file and list file
ActiveX scripts (VBScript, JScript and etc.)
Batch files, utilities and etc.
Groups and nesting
 
 
Custom Tasks
Support built-in and user-defined variables
Variables can be used within a task and embedded in TSQL scripts and or passed to sub-processes
Built-in:
startup_path, output_path
server, instance and server_instance
rsinstance, olapinstance
authmode, ssuser and sspwd
ssver, sspath, ssregroot and ssbatchrunner
output_name, internal_output_name
quietmode, compressionmode, genericmode and outputfoldermode
starttime, endtime
Environment variables
 
 
User-defined Variables
From configuration file designation or /V option designation possibility about under using
   SQLDIAG /V foo=bar
SQLDiag can prompt for variable values at runtime (console app only)
 
 
The effect which goes mad to Server
Performance
Minimal for collector itself (<10% CPU)
Usually equal to sum of selected diagnostics
Dominated by Profiler trace cost
Support objects
Created in tempdb and dropped afterward
Registry entries
None for console app
Deleted by service deregistration
 
 
GUI Configuration App
The creation and editing support against a configuration file
Against Collection, services the control support
Provides limited automatic problem diagnosis
 
 
SQLDiag vs. PSSDiag
Essentially the same tool (same code)
SQLDiag does not include support files for down level versions of SQL Server
SQLDiag does not support ZIP compression
SQLDiag can only be run by Administrators
 
 
Yukon SQLDiag vs. Sphinx SQLDiag
Yukon SQLDiag is a superset of Sphinx SQLDiag
Sphinx/Shiloh SQLDiag was a snapshot of error logs, configuration and etc.
No Perfmon, Profiler, blocking info, or customization
Snapshot collection only (no polling support)
No multi-instance or multi-machine support
No scheduling or built-in compression
Diagnostics collected serially rather than in parallel
 
 
FAQ
What’s the perf impact of running this?
Can I add new Perfmon counters or Profiler trace events?
Can I filter the Profiler trace?
Can I run SQLDiag via SQLAgent?
Can I add my own diagnostics to the collection set?
Can I collect diagnostics for Reporting Services, Analysis Services, Notification Services, etc.?
Can I customize the built-in scripts SQLDiag runs?
Can I run multiple instances of SQLDiag?
Is a 64-bit version available?
How do I troubleshoot problems with SQLDiag itself?
 
 
以上的過程是:
  1. 透過 Google 將韓文的 PPT 轉成 HTML
  2. 把韓文 HTML 貼到 Blog
  3. 用 Google 把該篇韓文 Blog 翻譯成英文
  4. 再把英文貼回 Blog

不知是否有更好的 idea 呢微笑

2 Comments

  1. Unknown
    Posted 2008 年 09 月 07 日 at 05:13:13 | Permalink | 回覆

    Hi,Do you need advertising displays, advertisement screens, LCD digital signage and LCD signages? Please go Here:www.amberdigital.com.hk(Amberdigital).we have explored and developed the international market with professionalism. We have built a widespread marketing network, and set up a capable management team dedicated to provide beyond-expectation services to our customers.
    amberdigital Contact Us
    E-mail:sstar@netvigator.com
    website:www.amberdigital.com.hk
    alibaba:amberdigital.en.alibaba.com[dc

  2. Unknown
    Posted 2008 年 09 月 27 日 at 13:39:23 | Permalink | 回覆

    Hi,Do you need advertising displays, screen advertisings, digital sign, digital signages and LCDs? Please go Here:www.amberdigital.com.hk(Amberdigital).we have explored and developed the international market with professionalism. We have built a widespread marketing network, and set up a capable management team dedicated to provide beyond-expectation services to our customers.
    amberdigital Contact Us
    website:www.amberdigital.com.hk
    alibaba:amberdigital.en.alibaba.com[cabdgciccdgjab]

發表迴響

在下方填入你的資料或按右方圖示以社群網站登入:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / 變更 )

Twitter picture

You are commenting using your Twitter account. Log Out / 變更 )

Facebook照片

You are commenting using your Facebook account. Log Out / 變更 )

Google+ photo

You are commenting using your Google+ account. Log Out / 變更 )

連結到 %s

%d 位部落客按了讚: