開啟防火牆(使用 netsh 設定防火牆)

將下列文字存成bat檔,然後執行bat

@echo =========  SQL Server Ports  ===================
@echo Enabling SQLServer default instance port 1433
netsh firewall set portopening TCP 1433 "SQLServer"

@echo Enabling Dedicated Admin Connection port 1434
netsh firewall set portopening TCP 1434 "SQL Admin Connection"

@echo Enabling conventional SQL Server Service Broker port 4022
netsh firewall set portopening TCP 4022 "SQL Service Broker"

@echo Enabling Transact-SQL Debugger/RPC port 135
netsh firewall set portopening TCP 135 "SQL Debugger/RPC"

@echo =========  Analysis Services Ports  ==============
@echo Enabling SSAS Default Instance port 2383
netsh firewall set portopening TCP 2383 "Analysis Services"

@echo Enabling SQL Server Browser Service port 2382
netsh firewall set portopening TCP 2382 "SQL Browser"

@echo =========  Misc Applications  ==============
@echo Enabling HTTP port 80
netsh firewall set portopening TCP 80 "HTTP"

@echo Enabling SSL port 443
netsh firewall set portopening TCP 443 "SSL"

@echo Enabling port for SQL Server Browser Service's 'Browse' Button

netsh firewall set portopening UDP 1434 "SQL Browser"

@echo Allowing multicast broadcast response on UDP (Browser Service Enumerations OK)
netsh firewall set multicastbroadcastresponse ENABLE

MSDASQL 64位元 32位元 使用

I couldn't get the MSDASQL drivers to work, but got a result with the ACE drivers (NOTE I am on 64-bit so using the ACE drivers). It might be that I need the 64 bit version of MSDASQL..... < http://blogs.msdn.com/b/sqlforum/archive/2010/12/20/faq-why-cannot-64-bit-msdasql-access-a-csv-text-file.aspx

SELECT * 
FROM OPENROWSET (
    'Microsoft.ACE.OLEDB.12.0', 
    'Text;Database=C:\LogReader\AccurateLogReader; ', 
    'SELECT * from Feeders.txt')

If you are on 32-bit, maybe try

SELECT * 
FROM OPENROWSET (
    'Microsoft.Jet.OLEDB.4.0', 
    'Text;Database=C:\LogReader\AccurateLogReader; ', 
    'SELECT * from Feeders.txt')

SQL 重建索引

SELECT 'ALTER INDEX [' + ix.name + '] ON [' + s.name + '].[' + t.name + '] ' +
       CASE
              WHEN ps.avg_fragmentation_in_percent > 15
              THEN 'REBUILD'
              ELSE 'REORGANIZE'
       END +
       CASE
              WHEN pc.partition_count > 1
              THEN ' PARTITION = ' + CAST(ps.partition_number AS nvarchar(MAX))
              ELSE ''
       END,
       avg_fragmentation_in_percent
FROM   sys.indexes AS ix
       INNER JOIN sys.tables t
       ON     t.object_id = ix.object_id
       INNER JOIN sys.schemas s
       ON     t.schema_id = s.schema_id
       INNER JOIN
              (SELECT object_id                   ,
                      index_id                    ,
                      avg_fragmentation_in_percent,
                      partition_number
              FROM    sys.dm_db_index_physical_stats (DB_ID(), NULL, NULL, NULL, NULL)
              ) ps
       ON     t.object_id = ps.object_id
          AND ix.index_id = ps.index_id
       INNER JOIN
              (SELECT  object_id,
                       index_id ,
                       COUNT(DISTINCT partition_number) AS partition_count
              FROM     sys.partitions
              GROUP BY object_id,
                       index_id
              ) pc
       ON     t.object_id              = pc.object_id
          AND ix.index_id              = pc.index_id
WHERE  ps.avg_fragmentation_in_percent > 10
   AND ix.name IS NOT NULL

如何安裝SmartMonitor

安裝前注意事項
1.OS要Windows XP
2.不要安裝在虛擬機器上 , 要獨立的PC
3.要先確定IIS服務沒有安裝 TCP Port 80和8080沒被佔用
4.確定Windows內建的防火牆沒有開啟
5.確定防毒軟體不會阻擋網路封包的收集
6.Vigor 有Monitor Port的請將安裝SmartMonitor的電腦直接接在Monitor Port , 如果沒有Monitor Port的請進管理畫面打開Lan 端的Mirror Port 功能 , 再將安裝SmartMonitor的電腦直接接在Mirror Port上面

DEMO INSTALL SMARTMONITOR

最新軟體下載

CommandField設定

BoundField 格式設定

可參閱http://msdn.microsoft.com/zh-tw/library/system.web.ui.webcontrols.hyperlinkfield.datanavigateurlformatstring(v=vs.80).aspx

HyperLinkerField設定