Shaun Cassells at MyITForum.com

SMS 2003 and ConfigMgr 2007, PowerShell, Scripting, Finance, Fitness and Fun

News

Locations of visitors to this page

May 2009 - Posts

Disk Partition Alignment Best Practices for SQL Server
Disk partition alignment is a powerful tool for improving SQL Server performance. Configuring optimal disk performance is often viewed as much art as science. A best practice that is essential yet often overlooked is disk partition alignment. Windows Server 2008 attempts to align new partitions out-of-the-box, yet disk partition alignment remains a relevant technology for partitions created on prior versions of Windows.This paper documents performance for aligned and nonaligned storage and why nonaligned partitions can negatively impact I/O performance; it explains disk partition alignment for storage configured on Windows Server 2003, including analysis, diagnosis, and remediation; and it describes how Windows Server 2008 attempts to remedy challenges related to partition alignment for new partitions yet does not correct the configuration of preexisting partitions.The following topics are also included: background information, implementation, vendor considerations, two essential correlations, valid starting partition offsets, and the simple protocol to align partitions, define file allocation unit size, and assign drive letters. It includes results from tests that show how partition alignment can affect performance for SQL Server 2008.For more information, please refer to the Disk Partition Alignment Best Practices for SQL Server whitepaper

source: Bink.nu

Posted: May 12 2009, 09:39 AM by scassells | with no comments
Filed under:
Windows 7 Certification Training: 071-680
Today, Stephen Rose, Sr. Community Manager at Microsoft announced the availability of the Windows 7 Learning Portal.  This site is currently showcasing great IT Pro readiness content, including 7 Silverlight Learning Snacks, free sample chapters from upcoming MS Press Books, Learning Plans, links to clinics/HOLs and more. The portal can be found at http://www.microsoft.com/learning/windows-7/default.mspx Also, check out the free 2-hour eLearning Clinic called What’s New in Windows 7 for IT Professionals.

 

Posted: May 07 2009, 10:46 AM by scassells | with no comments
Filed under:
3 methods to open a System Context command prompt

I was reading Chris Nackers post here: NT Authority Context Command Prompt

When it got me thinking of different ways to elevate your rights; I came up with two more:

  • 1) Using the system scheduled to launch a command prompt
    • a. at 16:30 /interactive cmd.exe
    • b. change the time to something soon
  • 2) SysInternals psexec
    • a. Psexec -s cmd.exe
    • b. Works great at opening as system on a remote machine too

Can you suggest any other quick methods?