Jairo Cetina

IOPS (Input/Output Operations Per Second, pronounced i-ops) is a common performance measurement used to benchmark computer storage devices like hard disk drives (HDD), solid state drives (SSD), and storage area networks (SAN). As with any benchmark, IOPS numbers published by storage device manufacturers do not guarantee real-world application performance.   IOPS can be measured with applications such as Iometer (originally developed by Intel), as well as IOzone and FIO and is primarily used with servers to find the best storage configuration.   The specific number of IOPS possible in any system configuration will vary greatly depending upon the variables the tester enters into the program, including the balance of read and write operations, the mix of sequential and random access patterns, the number of worker threads and queue depth, as well as the data block sizes. There are other factors which can also affect the IOPS results including the system setup, storage dri...

Problem: My server's CPU utilization high when my Windows virtual machine is mostly inactive. Workaround: To determine what HAL your virtual machine is using, then determine if you are running with the correct vCPU count for the HAL: Right-click the My Computer icon, and choose Properties . Click the Hardware tab. Click the Device Manager tab. Double-click the Computer icon to see which HAL is currently loaded. In the vSphere or VMware Infrastructure client, click on the virtual machine, then click the Summary tab and see how may vCPU's are configured. If you have 1 vCPU and your virtual machine operating system is configured for a Uniprocessor ACPI, your configuration is correct. If your virtual machine operating system is configured for 2 or more vCPUs and it is running with a Multiprocessor ACPI, your configuration is correct. Note : Downgrading the HAL from multiprocessor to uniprocessor is ...

Configure your ESX/ESXi IP address and FQDN: Goto: Configuration tab > Authentication Services > Properties Type your domain and you OU if you want: Type your Domain User and Password See you Active Directory Domain. Now you can manage your security groups by adding some groups under “Assign Permissions”: Assign Administrator permissions to Domain Admins: More Info: Configure a Host to Use a Directory Service

To transfer logins and passwords from a SQL Server 7.0 server to an instance of SQL Server 2000, or between two instances of SQL Server 2000, you can use the new DTS Package Transfer Logins Task in SQL Server 2000. To do this, follow these steps: Connect to the SQL Server 2000 destination server, move to the Data Transformation Services in SQL Server Enterprise Manager, expand the folder, right-click Local Packages , and then click New Package . After the DTS package designer opens, click Transfer Logins Task on the Task menu. Complete the information about the Source , Destination and Logins tabs as appropriate. More Info: http://support.microsoft.com/kb/246133/en-us

Problem: The file C:\Windows\Microsoft.NET\Framework\ version_number \mscorlib.tlb could not be loaded. An attempt to repair this condition failed because the file could not be found. Please reinstall this program. Workaround: For SQL Server 2005 To work around this problem, you must manually specify the correct path of the Mscorlib.tlb file in the registry. To do this, follow these steps: Click Start , click Run , type regedit, and then click OK . Locate the following registry subkey: HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\90\Tools\Shell\TlbAutoRepair\mscorlib.tlb Notes If you install SQL Server 2005 on 64-bit operating systems, locate the following registry subkey: HKEY_LOCAL_MACHINE\SOFTWARE\Wow6432Node\Microsoft\Microsoft SQL Server\90\Tools\Shell\TlbAutoRepair\mscorlib.tlb If you install SQL Server 2005 Express Edition with Advanced Services, locate the following registry subkey: HKEY_L...

To detect the MSI or Microsoft Installer version check the version of MSI.DLL in the %SystemRoot%\System32 folder, Example: Or Execute: msiexec.exe /?

Problem: ”Database diagram support objects cannot be installed because this database does not have a valid owner. To continue, first use the Files page of the Database Properties dialog box or the ALTER AUTHORIZATION statement to set the database owner to a valid login, then add the database diagram support objects.” Workaround: EXEC sp_dbcmptlevel 'database_name', '90'; go ALTER AUTHORIZATION ON DATABASE::database_name TO 'login' go use [database_name] go EXECUTE AS USER = N'dbo' REVERT go More Info: sp_dbcmptlevel http://msdn.microsoft.com/es-ar/library/ms178653.aspx ALTER AUTHORIZATION http://msdn.microsoft.com/es-ar/library/ms187359.aspx