SQL Server Performance

hep again please

Discussion in 'Performance Tuning for Hardware Configurations' started by lara99, Nov 20, 2007.

  1. lara99 New Member

    Guys I need some hardware help
    I tried googling but I think am not smart enough so please help

    this are list of how to's so please bare with me
    1.Can I know how to check the version of NTFS( is there an easy way)
    2.How to check whether the hardware drivers are uptodate on any machine
    3.how to check whether the windows server configured as stand-alone
    4.Is the "Application Response" setting, set to "Optimize Performance" for "Background Services?"
    Has security auditing been turned on?

    5.How large is the server's PAGEFILE.SYS swap file?
    6.Have unnecessary services been turned off?
    7.Have all unnecessary network protocols been turned off?

  2. Luis Martin Moderator

    1) cmd: fsutil fsinfo ntfsinfo c:
    2) Ask to your vendor or go to hardware web.
    3) Check if server is Main Domain Controler.
    4) My Computer, Advanced, Performance, Advanced.
    5) My Computer, Advanced, Performance, Virtual Memory.
    6) Tell me what are on, or take a look of some Brad Arcticles.
    7) What protocols are on?
    BTW: Sorry, but I don't believe you research in Google neither this forum.

Share This Page