Viewing 15 posts - 18,361 through 18,375 (of 49,552 total)
Too snarky?
http://www.sqlservercentral.com/Forums/Topic1306465-334-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
May 30, 2012 at 11:27 am
https://www.google.com/search?q=what+is+page+tracks+extents+modified+since+last+full+backup
First, second, third and fourth hits.
https://www.google.com/search?q=What+needs+to+be+done+to+recover+a+database+up+to+point+of+failure
First, second, third, fourth and fifth hits.
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 30, 2012 at 11:24 am
Chapter 4 of this: http://www.simple-talk.com/books/sql-books/troubleshooting-sql-server-a-guide-for-the-accidental-dba/
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 30, 2012 at 11:11 am
GilaMonster (5/30/2012)
May I suggest that you consider getting someone (a consultant good at optimisation) to redesign and tune the DB?
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 30, 2012 at 8:15 am
A primary key is backed by an index, you wouldn't create a second index on the same column, serves no point and wastes space
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 30, 2012 at 7:40 am
pallavi.unde (5/30/2012)
I have no idea about indexing actually...can you please tell how it can implement on database.
Did you read the articles?
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 30, 2012 at 7:34 am
You have no indexes? No wonder you have poor performance...
Start with these.
http://www.sqlservercentral.com/articles/Indexing/68439/
http://www.sqlservercentral.com/articles/Indexing/68563/
http://www.sqlservercentral.com/articles/Indexing/68636/
And I agree the database looks like it may need a bit of a redesign. May I suggest 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
May 30, 2012 at 6:50 am
Full backups do not and never have interfered with the log chain
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 30, 2012 at 6:05 am
prettsons (5/30/2012)
Schadenfreude-Mei (5/30/2012)
prettsons (5/30/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
May 30, 2012 at 5:57 am
tilew-948340 (5/29/2012)
I would have bet that it was because a 32 bit operating system can't read a 64 bit file coming from a 64 bit operating system...
32 bit vs 64...
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 30, 2012 at 2:15 am
Understand that, but without the plans debugging this is going to be very difficult. Also you need to check the waits that the query gets, lock waits if 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
May 30, 2012 at 2:07 am
Without more information, no. Check the exec plans to see if they are different. See if the long duration is due to blocking or some other wait.
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 30, 2012 at 1:10 am
L' Eomot Inversé (5/29/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
May 29, 2012 at 2:05 pm
??? You mean you're not running regular integrity checks? Why on earth not?
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 29, 2012 at 12:26 pm
Corruption is almost always an IO subsystem problem. Could be anything from IO drivers right down to the physical disks.
What does CheckDB say?
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 29, 2012 at 11:16 am
Viewing 15 posts - 18,361 through 18,375 (of 49,552 total)