public QueryStressSettings()
{
MainDbConnectionInfo = new DatabaseSelect.ConnectionInfo(this);
ShareDbSettings = true;
ParamDbConnectionInfo = new DatabaseSelect.ConnectionInfo();
MainQuery = "";
ParamQuery = "";
NumThreads = 1;
NumIterations = 1;
ParamMappings = new Dictionary <string, string>();
ConnectionTimeout = 15;
CommandTimeout = 0;
EnableConnectionPooling = true;
CollectIoStats = true;
CollectTimeStats = true;
ForceDataRetrieval = false;
}
public QueryStressSettings()
{
mainDBConnectionInfo = new DatabaseSelect.ConnectionInfo(this);
shareDBSettings = true;
paramDBConnectionInfo = new DatabaseSelect.ConnectionInfo();
mainQuery = "";
paramQuery = "";
numThreads = 1;
numIterations = 1;
paramMappings = new Dictionary <string, string>();
connectionTimeout = 15;
commandTimeout = 0;
enableConnectionPooling = true;
collectIOStats = true;
collectTimeStats = true;
forceDataRetrieval = false;
}
public QueryStressSettings()
{
MainDbConnectionInfo = new DatabaseSelect.ConnectionInfo(this);
ShareDbSettings = true;
ParamDbConnectionInfo = new DatabaseSelect.ConnectionInfo();
MainQuery = "";
ParamQuery = "";
NumThreads = 1;
NumIterations = 1;
ParamMappings = new Dictionary<string, string>();
ConnectionTimeout = 15;
CommandTimeout = 0;
EnableConnectionPooling = true;
CollectIoStats = true;
CollectTimeStats = true;
ForceDataRetrieval = false;
}
public QueryStressSettings()
{
mainDBConnectionInfo = new DatabaseSelect.ConnectionInfo(this);
shareDBSettings = true;
paramDBConnectionInfo = new DatabaseSelect.ConnectionInfo();
mainQuery = "";
paramQuery = "";
numThreads = 1;
numIterations = 1;
paramMappings = new Dictionary<string, string>();
connectionTimeout = 15;
commandTimeout = 0;
enableConnectionPooling = true;
collectIOStats = true;
collectTimeStats = true;
forceDataRetrieval = false;
}
private void getColumnsButton_Click(object sender, EventArgs e)
{
this.queryVariables = this.getParams();
SqlDataReader reader = null;
DatabaseSelect.ConnectionInfo DBInfo = settings.shareDBSettings ? settings.mainDBConnectionInfo : settings.paramDBConnectionInfo;
if (!DBInfo.TestConnection())
{
MessageBox.Show("You must set valid database connection information. Click the Database button to configure the settings.");
return;
}
using (SqlConnection conn = new SqlConnection(DBInfo.ConnectionString))
{
try
{
SqlCommand comm = new SqlCommand(paramQueryTextBox.Text, conn);
conn.Open();
reader = comm.ExecuteReader(CommandBehavior.SchemaOnly);
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
if (reader != null)
{
columnMapGrid.Rows.Clear();
paramValues.Clear();
for (int i = 0; i < reader.FieldCount; i++)
{
paramValues.Add(reader.GetName(i), reader.GetDataTypeName(i));
}
reader.Dispose();
foreach (string variable in queryVariables)
{
int colOrdinal = columnMapGrid.Rows.Add();
DataGridViewRow row = columnMapGrid.Rows[colOrdinal];
row.Cells[0].Value = variable;
row.Cells[0].ReadOnly = true;
//placeholder for columntype
row.Cells[1].Value = "";
row.Cells[1].ReadOnly = true;
DataGridViewComboBoxCell combo = new DataGridViewComboBoxCell();
combo.Items.Add("");
bool checkParam = false;
if ((sender.GetType() == typeof(System.String)) &&
((string)sender == "constructor") &&
settings.paramMappings.ContainsKey(variable))
{
checkParam = true;
}
foreach (string paramName in paramValues.Keys)
{
combo.Items.Add(paramName);
if (checkParam)
{
if (settings.paramMappings[variable] == paramName)
{
combo.Value = paramName;
row.Cells[1].Value = paramValues[paramName];
}
}
}
row.Cells[2] = combo;
}
}
}
}
private void go_button_Click(object sender, EventArgs e)
{
if (!this.settings.mainDBConnectionInfo.TestConnection())
{
MessageBox.Show("You must set valid database connection information. Click the Database button to configure the settings.");
return;
}
this.cancelled = false;
this.exitOnComplete = false;
this.exceptions = new Dictionary <string, int>();
this.totalIterations = 0;
this.totalTime = 0;
this.totalCPUTime = 0;
this.totalElapsedTime = 0;
this.totalTimeMessages = 0;
this.totalLogicalReads = 0;
this.totalReadMessages = 0;
this.totalExceptions = 0;
this.iterationsSecond_textBox.Text = "0";
this.avgSeconds_textBox.Text = "0.0";
this.actualSeconds_textBox.Text = "---";
this.cpuTime_textBox.Text = "---";
this.logicalReads_textBox.Text = "---";
this.go_button.Enabled = false;
this.cancel_button.Enabled = true;
this.iterations_numericUpDown.Enabled = false;
this.threads_numericUpDown.Enabled = false;
this.progressBar1.Value = 0;
SaveSettingsFromForm1();
this.totalExpectedIterations = this.settings.numThreads * this.settings.numIterations;
DatabaseSelect.ConnectionInfo paramConnectionInfo = settings.shareDBSettings ? settings.mainDBConnectionInfo : settings.paramDBConnectionInfo;
db_label.Text = "" +
"Server: " + paramConnectionInfo.Server +
((paramConnectionInfo.Database.Length > 0) ? (" // Database: " + paramConnectionInfo.Database) : (""));
LoadEngine engine = new LoadEngine(
this.settings.mainDBConnectionInfo.ConnectionString,
this.settings.mainQuery,
this.settings.numThreads,
this.settings.numIterations,
this.settings.paramQuery,
this.settings.paramMappings,
paramConnectionInfo.ConnectionString,
this.settings.commandTimeout,
this.settings.collectIOStats,
this.settings.collectTimeStats,
this.settings.forceDataRetrieval);
backgroundWorker1.RunWorkerAsync(engine);
this.start = new TimeSpan(DateTime.Now.Ticks);
mainUITimer.Start();
}