Viewing 15 posts - 25,516 through 25,530 (of 49,552 total)
Multiple files, separate physical drives, large enough to handle max load (*1.5 if you're paranoid)
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
June 14, 2011 at 6:22 am
Please run this and post the full and complete output.
DBCC CheckDB(<Database name>) WITH No_INFOMSGS, ALL_ERRORMSGS
Do you have a backup?
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
June 14, 2011 at 6:21 am
There are valid reasons to shrink databases (out of space is seldom a good one), but not on a regular basis.
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
June 14, 2011 at 4:48 am
That's based on the myth that SQL uses one thread per file. It is purely a myth. SQL can use multiple threads to access data regardless of the file layout.
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
June 14, 2011 at 3:02 am
Tell you what?
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
June 14, 2011 at 3:01 am
Duplicate post. No replies to this thread please. Direct replies to http://www.sqlservercentral.com/Forums/Topic1124791-364-1.aspx
Jim, I'd suggest you attach the screenshot to the other thread as that is the one with more detail
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
June 14, 2011 at 2:28 am
I hope you have a clean backup.
In the meantime, try dropping and then recreating all the XML indexes in that database (drop any secondary XML indexes, then drop the primaries...
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
June 14, 2011 at 2:25 am
Oracle_91 (6/14/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
June 14, 2011 at 2:16 am
Three tables, no joins?
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
June 14, 2011 at 12:10 am
Craig Farrell (6/14/2011)
I personally like bit fields, and bitmap fields.
Bits yes, bitmaps no.
Technically they violate 1st normal form. They're non-intuitive to people who haven't been exposed to them and 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
June 14, 2011 at 12:05 am
You don't have to use them, but in your case you could be updating far more of the table than you need. Say someone comes and does a one row...
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
June 14, 2011 at 12:01 am
Boaz51 (6/13/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
June 13, 2011 at 11:59 pm
Ninja's_RGR'us (6/13/2011)
There's clearly at least a verify on top of the backup, maybe there's something else we don't see.
Exactly. There's a verify at least (clear from the output you posted)...
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
June 13, 2011 at 11:50 pm
Syed Jahanzaib Bin hassan (6/13/2011)
3-Increase the Files in a FileGroups (when you have multiple Core or physical Processors)
The only time that is useful is if the DB is under IO...
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
June 13, 2011 at 11:49 pm
The SQL service account doesn't have permission to the folder or 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
June 13, 2011 at 4:01 pm
Viewing 15 posts - 25,516 through 25,530 (of 49,552 total)