Viewing 15 posts - 25,891 through 25,905 (of 49,552 total)
Please post execution plan and existing index definitions
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
May 27, 2011 at 2:35 am
Jim Murphy (5/26/2011)
I guess I'm in fantasy land since this scope is too big.
Huge, that's more a week's course.
In real live, do you really go for a trace and...
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
May 27, 2011 at 2:33 am
Elliott Whitlow (5/26/2011)
Jan Van der Eecken (5/26/2011)
GilaMonster (5/26/2011)
From the posts the person has made, they are totally out of their depth. 6TB DBs, major perf problems...
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
May 27, 2011 at 2:08 am
Matthew Spinks (5/26/2011)
When I run a maintenance job to rebuild indexes, verify database integrity, etc. that's when my logs fill!
Yeah, they will. Rebuild all indexes, in full recovery, needs something...
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
May 27, 2011 at 2:07 am
Why read every job? One job has failed, that job is the one you should be investigating. Looking at ones that haven't failed is just a waste of time.
Honestly, I'd...
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
May 26, 2011 at 12:25 pm
Fraggle-805517 (5/26/2011)
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
May 26, 2011 at 12:24 pm
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
May 26, 2011 at 10:41 am
Err, no I don't think so...
Grab the plans from cache, straight as they are, insert into a table. Get that data to another server (dev/test/monitoring server), do the xml querying...
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
May 26, 2011 at 9:51 am
Not a picture of the execution plan. The execution plan itself. See http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
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
May 26, 2011 at 9:20 am
Steve Jones - SSC Editor (5/26/2011)
I'll say that most of the better applications were self-written.
And most, if not all, of the worst ones....
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
May 26, 2011 at 9:03 am
One very uncomfortable PM sent...
From the posts the person has made, they are totally out of their depth. 6TB DBs, major perf problems and barely a clue.
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
May 26, 2011 at 8:58 am
Yup. The operators should be the same, the additional data on actual row count is the most useful .
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
May 26, 2011 at 8:56 am
Brandie Tarvin (5/26/2011)
GilaMonster (5/26/2011)
Roy Ernest (5/26/2011)
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
May 26, 2011 at 8:38 am
Post em?
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
May 26, 2011 at 8:38 am
Two things:
That's only going to work for tables that don't have a clustered index. Table scans of a table with a clustered index show as clustered index scans
Do not run...
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
May 26, 2011 at 8:34 am
Viewing 15 posts - 25,891 through 25,905 (of 49,552 total)