public void RunPoolTest()
{
try
{
string masterConnectionString = BuildConnectionString("master");
List<string> databases = CreateDatabases(masterConnectionString, ToolSettings.NumDatabases);
if (databases.Count != ToolSettings.NumDatabases)
{
DropDatabases(masterConnectionString, databases);
return;
}
const string sqlQuery = "SELECT 'SessionID=' + CAST(@@SPID AS varchar(20))";
_perfCounters = InitPerformanceCounters();
WritePerformanceCounters();
foreach (string dbName in databases)
{
using (SqlConnection sqlConn = new SqlConnection(BuildConnectionString(dbName)))
{
var sqlCmd = new SqlCommand(sqlQuery, sqlConn);
sqlConn.Open();
_viewModel.LogLines.AddLine((string)sqlCmd.ExecuteScalar());
}
}
WritePerformanceCounters();
//connectionString = BuildConnectionString("master");
//for (int i = 0; i < 10; i++)
//{
// using (SqlConnection sqlConn = new SqlConnection(connectionString))
// {
// var sqlCmd = new SqlCommand(sqlQuery, sqlConn);
// sqlConn.Open();
// tbQueryOutput.AppendText((string)sqlCmd.ExecuteScalar() + "\r\n");
// }
//}
//WritePerformanceCounters();
DropDatabases(masterConnectionString, databases);
_viewModel.LogLines.AddLine("");
_viewModel.LogLines.AddLine("Тестирование закончено");
}
finally
{
_viewModel.PoolTestRunning = false;
}
}