The SQL Server log is at the instance level only, there is no database level log.

It can be found by opening your SQL instance in Management Studio, then opening the...

I think to keep things simple having both the cluster and SQL VIP on the same vLAN is the way forward.

Thanks for the advice!

Andrew

Hi Perry,

Thank you for the quick response.

So having the cluster VIP on the Production vLAN would probably be the best way forward? I can put it on the management vLAN...

Odd, is there anything in Tools > Options > SQL Server Object Explorer > Scripting ?

Brent Ozar has a good blog post about running SQL 2012 on Windows Server 2008 and why Windows 2012 should be used:-

http://www.brentozar.com/archive/2014/03/need-high-availability-sql-server-windows-server-2012/

Logical reads are reads from memory whereas physical reads are reads from disk.

If the queries are not waiting on anything then the next thing I would look at is the...

Have a look at the Microsoft Virtual Academy:-

http://www.microsoftvirtualacademy.com/product-training/sql-server

Lots of good resources available

This link should give you some information about diverting read only traffic:-

http://msdn.microsoft.com/en-us/library/hh710054.aspx#RORReplicaProperties

However if you want to split the traffic between read only replicas, I'm honestly not too sure.

As far as I'm aware, you can have up to 4 secondary replicas in SQL 2012 and up to 8 in SQL 2014. So you should not have a problem...

Open up Configuration Manager and have a look at the status of the SQL Server Agent.

If it is starting, wait for it to be brought online otherwise start the service.

Andrew

I wouldn't recommend doing so. Your backup job is currently verifying the backup file, you should let it complete to ensure that your backup is valid.

Andrew

Would this help?

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

Hi, memory node id 64 is a logical node to support the Dedicated Admin Connection. It's not associated with any physical NUMA node.

From your screen shot I would say that...

Perry Whittle (5/29/2014)

---

DBA From The Cold (5/29/2014)

---

This all depends on the spec of the Production machine in my opinion. If the machine requires a small number of CPUs and a...

Completely agree with you on the nested views/stored procedures.

Trying to trouble shoot an issue when a stored procedure has called ten other procedures, which in turn call another load of...