string connString = "Data Source=****;Initial Catalog=****;Password=***;User ID=***";
            using (SqlConnection con = new SqlConnection(connString))
            {
                con.Open();
                string sql = "SET SHOWPLAN_XML ON";
                SqlCommand cmd = new SqlCommand(sql, con);
                cmd.ExecuteNonQuery();
                cmd.CommandText = "SELECT * FROM [T_Z_Events] WHERE [EventId] >= 4130";
                var rez = cmd.ExecuteScalar(); // план
                cmd.CommandText = "SELECT * FROM [T_Z_Events] WHERE [EventId] >= 4216";
                var rez1 = cmd.ExecuteScalar(); // план
                cmd.CommandText = "SET SHOWPLAN_XML OFF";
                cmd.ExecuteNonQuery();
                cmd.CommandText = "SELECT COUNT(*) FROM [T_Z_Events] WHERE [EventId] >= 4216";
                var cnt = cmd.ExecuteScalar(); // число
                con.Close();
            }