Viewing 15 posts - 15,241 through 15,255 (of 49,552 total)
I would start by tuning the queries.
If that doesn't work to remove the deadlocks, then and only then add a maxdop hint to those queries.
Server level, without knowing anything...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
December 13, 2012 at 11:24 am
You only ever need to restore the last differential backup. They're differentials, not incrementals. Restore the full backup, the last differential then, if you're restoring log backups as well, all...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
December 13, 2012 at 11:03 am
Someone's set up a DDL trigger and forgot to SET NOCOUNT ON in it.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
December 13, 2012 at 11:01 am
Yup, that's intra-query parallelism
Tune the query so that it doesn't need to parallel (or just to get a more efficient plan) or put a maxdop hint on the query.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
December 13, 2012 at 10:59 am
Michael Fried (12/13/2012)
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
December 13, 2012 at 10:02 am
MSSQL_NOOB (12/13/2012)
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
December 13, 2012 at 8:42 am
When the log gets full, they will both grow. If the log is not full, then the files aren't going to grow. If you have 148 GB free in the...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
December 13, 2012 at 8:30 am
GSquared (12/13/2012)
Sch-M locks are schema locks. Means you can't change the definition of the table during the bulk insert.
Sch-M is a schema modification lock. Taken by the...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
December 13, 2012 at 8:11 am
What am I supposed to be seeing there, other than 2 files of the same size?
You said in your initial post "both the logs are growing at the same rate....
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
December 13, 2012 at 8:08 am
Anything written by Itzik Ben-Gan
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
December 13, 2012 at 7:33 am
davidandrews13 (12/13/2012)
isn't it just looking for the student_id column, not finding it in the emp table, so its taking it from the student table?
Exactly what it is doing.
It is...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
December 13, 2012 at 4:28 am
rajkiran.panchagiri (12/13/2012)
Is there any other way other than this?
Not really. Setting the DB to read only or single user for the duration of the backup is the simplest. The question...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
December 13, 2012 at 3:54 am
There's no official list because many traceflags are undocumented or confidential. Microsoft is not going to go and document a list of undocumented traceflags
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
December 13, 2012 at 2:36 am
Yeah, that's pretty unrecoverable.
You may want to do some investigation of the IO subsystem, before it messes up again and corrupts the data file.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
December 12, 2012 at 2:12 pm
You can't commit it. It has to finish the rollback.
Trying to kill it will not cause a corrupt database (there is nothing that a user can do via T-SQL that...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
December 12, 2012 at 1:08 pm
Viewing 15 posts - 15,241 through 15,255 (of 49,552 total)