Viewing 15 posts - 16,156 through 16,170 (of 49,552 total)
Bhuvnesh (10/12/2012)
GilaMonster (10/12/2012)
What do you need me to explain? The index is redundant, it's a subset of an existing index
So you mean to say here that another ( single...
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
October 12, 2012 at 12:02 pm
Doesn't sound like bad plans then, or at least not the type that can be fixed with a recompile. Considered gettign a consultant in?
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
October 12, 2012 at 9:54 am
DBA should be focused on fixing or preventing problems. So, is the TempDB usage a problem?
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
October 12, 2012 at 9:50 am
Honestly, I would doubt it. As far as I know, the traceflag was documented because it was used in a TPC benchmark, and they require that all options be documented....
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
October 12, 2012 at 9:49 am
Async network IO, despite it's name, seldom has anything to do with network. It's a wait mainly from the client being slow to accept the resultset
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
October 12, 2012 at 8:58 am
Nothing probably.
Is 200 MB of TempDB usage a problem? Is it excessive? Is it unusual?
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
October 12, 2012 at 8:51 am
Oh wow, that's horrid...
The main problem here is the 'believes'. Performance recommendations should never be made on what someone believes may be happening. They should be based on what exactly...
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
October 12, 2012 at 8:49 am
No need to rebuild nonclustered indexes after creating a clustered index. The nonclustered indexes will all be rebuild automatically when a clustered index is created or dropped
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
October 12, 2012 at 8:40 am
That would require that the largest portion of contiguous memory available is under 512 MB. If that's the case, I suspect there's more of a problem than just SQL Server...
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
October 12, 2012 at 5:43 am
Perry Whittle (10/12/2012)
GilaMonster (10/11/2012)
I don't recommend enabling large pages, it can have some effects at startup and it doesn't usually help much, if at all
+ 1
When you enable large pages...
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
October 12, 2012 at 2:38 am
Bhuvnesh (10/12/2012)
GilaMonster (10/12/2012)
Yes. Statistics updates have no effect whatsoever on the structure, density, fragmentation or layout of an index.
structure and layout of index i can understand but how come...
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
October 12, 2012 at 2:16 am
Yes. Statistics updates have no effect whatsoever on the structure, density, fragmentation or layout of an index.
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
October 12, 2012 at 1:46 am
Low page density from fragmentation or deletes.
p.s. The smaller index is redundant, it's unlikely to be needed.
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
October 12, 2012 at 1:26 am
Yeah, that helps.
Now what, exactly do you want to see returned from that set of data (list rows and columns)
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
October 12, 2012 at 1:11 am
For the data listed there, what should the results be?
Also, any chance you can post create table statements and the sample data as inserts (easier to use)?
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
October 11, 2012 at 4:41 pm
Viewing 15 posts - 16,156 through 16,170 (of 49,552 total)