I think Andrew would agree also, what is your RTO; Recovery Time Objective?

The recovery time objective (RTO) is the targeted duration of time and a service level within...

Hi, what is the problem you are trying to solve? The lowest I have ever seen in a production environment is every 5 minutes. Probably, the most common...

Cumulative updates are exactly that - (cumulative). So, you can apply the latest (last) CU after a service pack was released and be assured you are getting all the...

If you are completely shutting down the cluster (within Failover Cluster Manager) both of the sql services on all nodes within the cluster will be stopped. As soon as...

Hi Mike,

What Statistics option if any are you using in the Ola index command?

ALL - Update index and column statistics.

INDEX - Update index statistics.

COLUMNS -...

Thanks Jacob, yeah, depends on what his needs are.

I would replace this: INSERT INTO tempdb..#members_roles(RoleName, MemberName)

with INSERT INTO tempdb..members_roles(RoleName, MemberName) - taking out the # because it is not needed but implicitly implied. Also take it...

If Sql Server is the only thing running on the server (a dedicated server) - I would increase the MAXMEM to another higher value and then see if you still...

Ok, so you are only allowing Sql Server to use 8GB of the available 40GB on the server, is this correct?

As a start, what is the instance's MAXMEM setting set to?

--

http://msdn.microsoft.com/en-us/library/ms156293.aspx

This can be done by connecting to SSRS through the SQL Server Management Studio (SSMS) by specifying a server type of "Reporting Services"

--

Have you installed Report Builder on...

My favorite and used in our prod env - https://www.brentozar.com/blitz/configure-sql-server-alerts/

General info - https://www.mssqltips.com/sqlservertip/2121/event-notifications-in-sql-server-for-tracking-changes/

Compares event notifications to extended events - https://www.sqlskills.com/blogs/jonathan/event-notifications-vs-extended-events/

I would say if the login must be dropped, you have no choice but to drop the event notification prior. I looked around and there does not appear to...

Give this query a whirl and see if it is what you are looking for - -- Get a count of SQL connections by IP address

SELECT dec.client_net_address ,

des.program_name ,

des.host_name ,

--des.login_name...

The Sql Server Agent is a very important service that must run for the instance, like you mention at the very least, to be able to run Sql jobs. ...