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

Monday, March 25, 2013

How can you tell if VAAI is enabled?

To determine if VAAI is enabled using the vSphere Client:
  1. In the vSphere Client inventory panel, click the host.
  2. Click the Configuration tab, then click Advanced Settings under Software.
  3. Check that these options are set to 1 (enabled):

    DataMover.HardwareAcceleratedMove
    DataMover.HardwareAcceleratedInit
    VMFS3.HardwareAcceleratedLocking
What do I need to know about the Hardware Acceleration Support Status?
If you go to Host > Configuration > Storage, you can see the Hardware Acceleration Status in the panel on the right side.

For each storage device and datastore, the vSphere Client displays the hardware acceleration support status in the Hardware Acceleration column of the Devices view and the Datastores view.

The status values are Unknown, Supported, and Not Supported. The initial value is Unknown. The status changes to Supported after the host successfully performs the offload basic operations. If the offload operation fails, the status changes to Not Supported.

Reference:
http://kb.vmware.com/selfservice/microsites/search.do?language=en_US&cmd=displayKC&externalId=1021976

Performance analysis for SQL

Good reference regarding performance monitoring/analysis for SQL server.

Reference:
http://technet.microsoft.com/en-us/library/cc966540.aspx (SQL 2005)
http://msdn.microsoft.com/en-us/library/dd672789(v=sql.100).aspx (SQL 2008)

Friday, March 8, 2013

Request SSL cert for IIS7 (WIn 2008)

Different IIS manager interface so could not find how to generate a new SSL cert request.  Anyway, see reference for the how to...

Reference:
http://technet.microsoft.com/en-us/library/cc732906
http://www.digicert.com/ssl-certificate-installation-microsoft-iis-7.htm

Wednesday, January 30, 2013

Mysterious Active Directory lockouts

Something new I learned about Win 7 today is that there is a Control Panel called "Credential Manager". 

Users were having random lockouts to accounts and we were unable to determine the cause.  Turned out because they had selected save password, when logging into sharepoint or mapping a network share or other, causing Credential Manager to store that info.

The problem with that is it seems that if you changed your password, Credential Manager, doesn't know, keeps trying to use your old password, and triggers account lockouts.

References:
http://anandthearchitect.wordpress.com/2011/10/25/active-directory-account-lockout-issues/
http://technet.microsoft.com/nl-nl/library/cc773155(v=ws.10).aspx