WARNING: These commands are permanent. All deleted data will be lost. Ensure that you complete a full data backup before proceeding with these commands.
\n\n
The following commands will delete all performance data prior to a specified date:
\n\n\nselect min(id) from performance_sample where CONVERT(CHAR(10),sample_time,120) = 'DATE';
\ndelete from performance_aggregate where sample_id <ID; go;
\ndelete from performance_cpu where sample_id <ID; go;
\ndelete from performance_disk where sample_id <ID; go;
\ndelete from performance_esx3_workload where sample_id <ID; go;
\ndelete from performance_fscap where sample_id <ID; go;
\ndelete from performance_network where sample_id <ID; go;
\ndelete from performance_nrm where sample_id <ID; go;
\ndelete from performance_psinfo where sample_id <ID; go;
\ndelete from performance_vmware_workload where sample_id <ID; go;
\ndelete from performance_vxvol where sample_id <ID; go;
\ndelete from performance_who where sample_id <ID; go;