Monday, June 24, 2013

Adding Mgt Network to IE Local Intranet Zone

  1. Open GPEDIT.MSC as administrator
  2. Go to Computer Configuration/Administrative Templates/Windows components/Internet Explorer/Internet Control Panel/Security Page.
  3. Enable Site to Zone Assignment List
  4. Add IP segment, ie. 192.168.0.* with value = 1 (for local intranet, 2=trusted sites).
  5. Close all browser session, then test.

Thursday, June 20, 2013

Troubleshooting SQL server RESOURCE_SEMAPHORE Wait Type

Application users were complaining that web applications were slow.  Turned out there were some bad queries that were requesting up to 1GB of SQL RAM to execute.  It's no wonder SQL was suspending queries waiting for memory...

Reference:
http://www.mssqltips.com/sqlservertip/2827/troubleshooting-sql-server-resourcesemaphore-waittype-memory-issues/
http://blogs.msdn.com/b/sqlqueryprocessing/archive/2010/02/16/understanding-sql-server-memory-grant.aspx

Friday, June 14, 2013

WSUS client options

Reference below includes definitions of the regkeys that can be set for different options on the a WSUS client server.

Reference:
http://technet.microsoft.com/en-us/library/cc708449(v=ws.10).aspx

Thursday, May 23, 2013

Friday, May 3, 2013

How to change default Hypertext Transfer Protocol(HTTP) or HTTPS ports in DataFabric Manager(DFM)

By default, port 8080 is used for HTTP and 8443 is used for HTTPS.

To change the HTTP port
  1. Enter the following command:
  2. dfm option set httpPort=
    You will be prompted to restart the HTTP service.
  3. Stop the http service:
  4. dfm service stop http
  5. Start the http service: dfm service start http
To change the HTTPS port
  1. Enter the following command:
  2. dfm option set httpsPort=
    You will be prompted to restart the HTTP service.
  3. Stop the http service:
  4. dfm service stop http
  5. Start the http service:
  6. dfm service start http

Reference:
https://kb.netapp.com/support/index?page=content&id=1011886&actp=search&viewlocale=en_US&searchid=null