bool StartProcess()
{
try
{
Steps.ClickOnFile();
Steps.SelectConnectRepoOption();
Steps.ClickOnConnect();
Steps.SelectServer(Config.ServerOptions_DEFAULTSERVER);
Steps.ClickOnQueriesTab();
Steps.ClickOnSignatureMode();
Steps.ClickOnConfigureQueryMonitor();
Steps.CheckEnableQueryMonitor();
Steps.VerifyQueryPlanOptionsEnable();
Steps.EnterTextInQueryPlan(-1);
Steps.ClickOnOkInMSSP();
Steps.ClickOnConfigureQueryMonitor();
Steps.VerifyQueryPlanValue(1);
Steps.ClickOnOkInMSSP();
Common.UpdateStatus(1); // 1 : Pass
}
catch (Exception ex)
{
Common.UpdateStatus(5); // 5 : fail
Reports.ReportLog(ex.Message, Reports.SQLdmReportLevel.Fail, null, Config.TestCaseName);
}
return(true);
}
bool StartProcess()
{
try
{
Steps.ClickOnFile();
Steps.SelectConnectRepoOption();
Steps.ClickOnConnect();
Steps.SelectServer(Config.ServerOptions_CMWIN2016S8);
Steps.ClickOnQueriesTab();
Steps.ClickOnSignatureMode();
Steps.ClickOnConfigureQueryMonitor();
Steps.CheckEnableQueryMonitor();
Steps.ClickOnExtendedEvents();
Steps.CheckCollectActualQueryPlans();
Steps.EnterTextInDurationMS(50);
Steps.EnterTextInQueryPlan(5);
Steps.SelectValueInPlansBy("CPU usage (milliseconds)");
Steps.ClickOnAdvancedTab();
Steps.UnCheckExcludeSQLDMQueries();
Steps.ClickOnOkInAQFC();
Steps.ClickOnOkInMSSP();
Steps.ClickOnWarningYes();
Common.WaitForSync(420000);
Steps.ClickOnConfigureQueryMonitor();
Steps.UnCheckEnableQueryMonitor();
Steps.ClickOnOkInMSSP();
Steps.VerifyQueryDataForTopQueryPlan(Config.Query_CPUUsage, "CPU Usage");
}
catch (Exception ex)
{
Reports.ReportLog(ex.Message, Reports.SQLdmReportLevel.Fail, null, Config.TestCaseName);
}
return(true);
}
bool StartProcess()
{
try
{
Steps.SelectServer(Config.ServerOptions_DEFAULTSERVER);
Steps.ClickOnQueriesTab();
Steps.ClickOnSignatureMode();
Steps.ClickOnConfigureQueryMonitor();
Steps.CheckEnableQueryMonitor();
// Steps.SelectServer(Config.ServerOptions_DEFAULTSERVER); //Version 2016
// Steps.ClickOnQueriesTab();
// Steps.ClickOnSignatureMode();
// Steps.ClickOnConfigureQueryMonitor();
// Steps.CheckEnableQueryMonitor();
Steps.VerifyQueryStoreRB();
Steps.ClickOnOkInMSSP();
Steps.ClickOnWarningYes();
// Steps.SelectServer(Config.ServerOptions_DEFAULTSERVER); //Version 2017
// Steps.ClickOnQueriesTab();
// Steps.ClickOnSignatureMode();
// Steps.ClickOnConfigureQueryMonitor();
// Steps.CheckEnableQueryMonitor();
// Steps.VerifyQueryStoreRB();
// Steps.ClickOnOkInMSSP();
// Steps.ClickOnWarningYes();
Common.UpdateStatus(1); // 1 : Pass
}
catch (Exception ex)
{
Common.UpdateStatus(5); // 5 : fail
Reports.ReportLog(ex.Message, Reports.SQLdmReportLevel.Fail, null, Config.TestCaseName);
}
return(true);
}
bool StartProcess()
{
try
{
Steps.ClickOnFile();
Steps.SelectConnectRepoOption();
Steps.ClickOnConnect();
Steps.SelectServer(Config.ServerOptions_CMWIN2016S8);
Steps.ClickOnQueriesTab();
Steps.ClickOnSignatureMode();
Steps.ClickOnConfigureQueryMonitor();
Steps.CheckEnableQueryMonitor();
Steps.VerifyQueryPlanOptionsEnable();
Steps.EnterTextInQueryPlan(-1);
Steps.ClickOnOkInMSSP();
Steps.ClickOnWarningYes();
Steps.ClickOnConfigureQueryMonitor();
Steps.VerifyQueryPlanValue(1);
//Steps.EnterTextInQueryPlan(ABC);
Steps.ClickOnOkInMSSP();
Steps.ClickOnWarningYes();
Steps.ClickOnConfigureQueryMonitor();
Steps.VerifyQueryPlanValue(1);
}
catch (Exception ex)
{
Reports.ReportLog(ex.Message, Reports.SQLdmReportLevel.Fail, null, Config.TestCaseName);
}
return(true);
}
bool StartProcess()
{
try
{
Steps.SelectServer(Config.ServerOptions_TMSSQL2016); //Version 2016
Steps.ClickOnQueriesTab();
Steps.ClickOnSignatureMode();
Steps.ClickOnConfigureQueryMonitor();
Steps.CheckEnableQueryMonitor();
Steps.VerifyQueryStoreRB();
Steps.ClickOnOkInMSSP();
Steps.ClickOnWarningYes();
Steps.SelectServer(Config.ServerOptions_CMWIN2016SQL17); //Version 2017
Steps.ClickOnQueriesTab();
Steps.ClickOnSignatureMode();
Steps.ClickOnConfigureQueryMonitor();
Steps.CheckEnableQueryMonitor();
Steps.VerifyQueryStoreRB();
Steps.ClickOnOkInMSSP();
Steps.ClickOnWarningYes();
}
catch (Exception ex)
{
Reports.ReportLog(ex.Message, Reports.SQLdmReportLevel.Fail, null, Config.TestCaseName);
}
return(true);
}
bool StartProcess()
{
try
{
Steps.ClickOnFile();
Steps.SelectConnectRepoOption();
Steps.ClickOnConnect();
Steps.SelectServer(Config.ServerOptions_CMWIN2016S8);
Steps.ClickOnQueriesTab();
Steps.ClickOnSignatureMode();
Steps.CheckEnableQueryMonitor();
//Steps.VerifyQueryPlansStatus("enable");
//Steps.EnterTextInSelectTop("1");
//Steps.ClickOnOnInMSSP();
Common.UpdateStatus(1); // 1 : Pass
}
catch (Exception ex)
{
Common.UpdateStatus(5); // 5 : fail
Reports.ReportLog(ex.Message, Reports.SQLdmReportLevel.Fail, null, Config.TestCaseName);
}
return(true);
}
bool StartProcess()
{
try
{
Steps.ClickOnFile();
Steps.SelectConnectRepoOption();
Steps.ClickOnConnect();
Steps.SelectServer(Config.ServerOptions_DEFAULTSERVER);
Steps.ClickOnQueriesTab();
Steps.ClickOnSignatureMode();
Steps.ClickOnConfigureQueryMonitor();
Steps.CheckEnableQueryMonitor();
Steps.ClickOnExtendedEvents();
Steps.CheckCollectActualQueryPlans();
Steps.EnterTextInDurationMS(50);
Steps.EnterTextInQueryPlan(5);
Steps.SelectValueInPlansBy("Logical disk reads");
Steps.ClickOnAdvancedTab();
Steps.UnCheckExcludeSQLDMQueries();
Steps.ClickOnOkInAQFC();
Steps.ClickOnOkInMSSP();
Steps.ClickOnWarningYes();
Common.WaitForSync(20000);
//Common.WaitForSync(420000);
Steps.ClickOnConfigureQueryMonitor();
Steps.UnCheckEnableQueryMonitor();
Steps.ClickOnOkInMSSP();
Steps.VerifyQueryDataForTopQueryPlan(Config.Query_LogicalDiskReads, "LogicalDiskReads");
Common.UpdateStatus(1); // 1 : Pass
}
catch (Exception ex)
{
Common.UpdateStatus(5); // 5 : fail
Reports.ReportLog(ex.Message, Reports.SQLdmReportLevel.Fail, null, Config.TestCaseName);
}
return(true);
}