Viewing 15 posts - 35,671 through 35,685 (of 49,552 total)
There's also a chapter in the MVP Deep dives book - http://www.sqlservermvpdeepdives.com/
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
November 25, 2009 at 12:13 am
For many counters there's no single threshold where below is good and above is bad, it's not that easy. For many, you need a baseline for what's normal in your...
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
November 24, 2009 at 11:50 am
jmartinez-847815 (11/24/2009)
Another item to note is when I run the query analyzer with the 2848 data it suggests I delete ALL indexes within these three tables.
I assume you...
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
November 24, 2009 at 11:13 am
Can you also try a statistics update with full scan on the Drivers table? The row estimates are way off, probably contributing to the poor plan. Weird thing is, there...
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
November 24, 2009 at 11:11 am
Can you give me the definition of this index please
[tblAUPolicy].[_dta_index_tblAUPolicy_7_357576312__K2_K115_K1_112_113_114_116_117_118]
In fact, can you give the definitions of all the indexes on that table?
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
November 24, 2009 at 10:29 am
ico-601891 (11/24/2009)
Someone could give me any other alternative solution?
Maybe, if you can post the full stored procedure, some info on the tables and indexes and the execution plan, as previously...
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
November 24, 2009 at 9:50 am
Considering there are range shared locks involved, probably yes. Question is, is serialisable needed. If not, dropping to repeatable read or read committed will probably make this go away....
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
November 24, 2009 at 9:49 am
Can you post the definitions of the two procedures involved (QDB_Central.dbo.uspUpdateOrgUnitAcknowledgements and QDB_Central.dbo.EnqueueMessage), the definitions of the table involved (QueueData) with all of its indexes.
Why are you using the serializable...
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
November 24, 2009 at 8:55 am
It's using the clustered index when you do SELECT * because the cluster contains all the columns and you're asking for all the columns. If it used the nonclustered 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
November 24, 2009 at 8:46 am
Brain dumps are cheating. They are questions taken from the actual exams, in violation of the NDA that anyone taking the exam has to accept. Using or distributing braindumps can...
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
November 24, 2009 at 8:41 am
Suresh B. (11/24/2009)
I thought there is some way to restore as the compatibility is not changed.
Compatibility level has nothing to do with database version. The compatibility level just affects...
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
November 24, 2009 at 8:39 am
simegh (11/24/2009)
I have not backup. I set emergency mode and repair.
You do realise that you may very well have lost data. You will certainly have lost any transactions 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
November 24, 2009 at 8:27 am
Post execution plans?
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
November 24, 2009 at 12:26 am
Duplicate post (and possible spam). No replies to this thread please. Direct replies to:http://www.sqlservercentral.com/Forums/Topic823640-6-1.aspx
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
November 24, 2009 at 12:22 am
Joie Andrew (11/23/2009)
It appears that from the error that either the log file is missing or is not in a location that it was expecting it to be in.
As far...
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
November 24, 2009 at 12:21 am
Viewing 15 posts - 35,671 through 35,685 (of 49,552 total)