Have you found anything online about this waittype? I have a new server that's showing this as the highest waittype

PatternSample EndedSeconds Samplewait_typeWait Time (Seconds)Signal Wait Time (Seconds)Percent Signal WaitsNumber...

Hilarious responses today - Some people need to have a drink and relax a little :w00t:

similar to what was already suggested, you can start by comparing the results of

SELECT * from sys.configurations order by NAME

+1 to the rest of the comments; but there could be many reason for the timeout errors. Clearly indexes/statistics can cause performance issues....and since you changed a column data...

It's possible but I haven't found any instances of that (I scrutinize heavily for those types of performance killers) 😀

Steve Jones - SSC Editor (6/23/2015)

---

Q1: @ @servername contains the name of the instance. Include that in your subject or message.

Q2: doesn't make sense. What do you mean by avoid...

A few things:

Opinion: Your fragmentation level check is set way too low (5% - consider changing this to 10% or 15% as that really isn't a lot of fragmentation unless...

I'm puzzled by this "with backup device creating backups with a new transaction log for each day"

How is it possible that it's creating a new physical transaction log file daily?...

comeraghsolutions (6/5/2015)

---

Currently we has a database of size about 300G. Because our backup system failed some time past we were left with a transaction log file which grew to...

Are you attempting to start the service via the SQL Server Configuration Manager? If so, try doing it from the services applet in the control panel and see if it...

A permissions problem would most likely result in an error, the fact that the user doesn't get an error and just receives a blank screen leads me to believe that...

It was in the link I added in my OP CREATE FUNCTION [dbo].[fx_DelimitedSplit8K]

--===== Define I/O parameters

(@pString VARCHAR(8000), @pDelimiter CHAR(1))

RETURNS TABLE WITH SCHEMABINDING...

Has anyone else been through this?

I created a simple scalar function that checks if the folder exists, if it doesn't it creates it - it depends on Jeff Moden's awesome function DelimitedSplit8K, but you can...

sheba.sql (6/3/2015)

---

I have Credentials stored in the report for the Data source and also i am using a select statement in the report not calling any store procedure. User is...