SeniorITGuy (7/26/2016)

---

VastSQL,

Can you clarify what storage goes down? The VMWare data store or disks assigned to the SQL cluster if you are using in guest iSCSI?

If the ESXi host has...

Perry Whittle (7/25/2016)

---

VastSQL (7/25/2016)

---

Perry Whittle (7/24/2016)

---

can you please supply more information on the environment itself and the configuration of the cluster nodes (e.g. number of vCPUs, vNICs, etc).

Have you run...

Perry Whittle (7/24/2016)

---

can you please supply more information on the environment itself and the configuration of the cluster nodes (e.g. number of vCPUs, vNICs, etc).

Have you run a cluster validation...

GilaMonster (7/20/2016)

---

You don't need to quote the whole thing again.

Is the CheckDB output in the inital post the pre-repair output (as your post implies) or the post-repair output (what I...

Hi All,

This turned out to be an issue with network.

seaport (7/15/2016)

---

VastSQL,

Thanks for the great tip. I checked the sql server log and it shows a fatal exception with a SQL Dump.

"SqlDumpExceptionHandler: Process 2396 generated fatal exception c0000005 EXCEPTION_ACCESS_VIOLATION....

GilaMonster (3/11/2016)

---

After the fact, you don't. At the time it occurs, you could use something like Process Explorer to identify what has the file handle open.

Make sure your antivirus is...

Is there any particular job running?

You can shrink the DB but make sure no connection to TempDB

Have you set a high value as initial Size for TempDB Files?

APA0876 (7/8/2016)

---

Hi,

We are planning to install Always On Availability Group on a Windows Cluster (three nodes), but for some reasons we are not able to create WSFC because we do...

seaport (7/8/2016)

---

The SQL 2014 is on version 12.0.2000.8 (64X).

I have a stored procedure for daily full backup of every database (except for temp) to a backup hard drive, one bak...

Grant Fritchey (7/11/2016)

---

How are your wait statistics?

This indicator is just an indicator of load. If it goes up or down compared to the baseline (which I get that you're just...

Trying to create a baseline and this is the highest i got.

Eirikur Eiriksson (7/11/2016)

---

VastSQL (7/11/2016)

---

Hi Experts,

The BatchRequest\Sec value for our OLTP system is showing 150 for the most critical time. I felt this as very low , can you guide me...

Chuck Bevitt (6/28/2016)

---

I've been getting deadlocks in a simple query like:

Select {data}

From

DataTable DT

Inner Join SetTable ST on ST.SetTableID = DT.SetTableID

Where {filter in part by flag in SetTable}

I was a little...