Base de Conocimientos

Problem In an ideal world all of our queries would be optimized before they ever make it to a production SQL Server environment, but this is not always the case. Smaller data sets, different hardware, schema differences, etc. all effect the way our queries perform. This tip will look at a method of automatically collecting and storing poor performing SQL statements so they can be analyzed at a later date. Solution With the new Dynamic Management Views and functions available starting in SQL Server 2005, capturing information regarding the performance of you SQL queries is a pretty straightforward task. The following view and functions give you all the information you need to determine how the SQL in you cache is performing: sys.dm_exec_query_stats sys.dm_exec_sql_text(sql_handle) sys.dm_exec_query_plan(plan_handle) Using the view and functions above we can create a query that will pull out all the SQL queries that are currently in the cache. Along with the...

VMware vSphere   is the most robust virtualization solution today. Cloning a   Virtual Machine (VM) in   ESxi   5.1 is a feature of vCenter server. Out of the box vSphere free edition hypervisor does not support cloning. But there is an alternative way to clone a VM. vSphere client version In this example we will use version 5.1.0. vSphere client connection First connect to the VSphere using the vSphere client and power off the source VM. vSphere client User Interface Select the Configuration tab and Storage settings on the left menu. The Datastores list will come up on the right pane. vSphere Datastores Right click on the datastore of the source VM and select Browse. Datastore Right click on the root folder on the left tree and create a new folder. e.g Application Copying the files Select the source folder of the VM to be cloned (2008R2 Machine in this example) and select the configuration file (.vmx) and the virtual disk file (...

In this tutorial I will demonstrate how you can move your virtual machine from one datastore on another using VMWare ESX 5 using the Vsphere client. Before you start make sure that the virtual machine that you want to move has been powered off . In my example I have two datastores, one of 300 GB and the other one is 600 GB. I want to move a VM from the 600 GB drive to the 300 GB drive. Click on your ESXi host and select Configuration > Datastore where your VM is located and click on Browse Datastore . You will see an overview of everything in the datastore. I want to move a virtual machine called “MMOBSERVIUM01″. Select the virtual machine and click on the Move button in the toolbar. You will see a confirmation screen, just click Yes to continue. Now we select the datastore where we want to move the VM to. In my example I select the 300 GB datastore. Optionally you can select a folder where you want to move the virtual machine to…Click Move to continue. You...