Viewing 15 posts - 14,671 through 14,685 (of 49,552 total)
How big's the index? How many 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
January 23, 2013 at 7:12 am
Can you post the table definition and all index definitions for dbo.order?
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
January 23, 2013 at 7:04 am
Personally I'd go for either consolidating databases onto fewer instances or consolidating physical machines into virtual machines on a single powerful server. Multiple instances on a single machine, not my...
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
January 23, 2013 at 6:54 am
sp_changedbowner:
This feature will be removed in a future version of Microsoft SQL Server. Avoid using this feature in new development work, and plan to modify applications that currently use this...
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
January 23, 2013 at 6:23 am
bugg (1/23/2013)
Hi Anthony, I don't have any deadlock XML in my error log but i do have the information above just broken up into lines.
That's a deadlock graph. 2 actually,...
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
January 23, 2013 at 6:18 am
Mostly.
You can restore the full, then any log backups. However, what happens if that full is damaged and won't restore? If you've deleted the log backups prior to it, then...
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
January 23, 2013 at 12:50 am
You can check the default trace. It logs DDL along with the login. If enough time has passed that the event is not in the default trace, there's likely no...
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
January 23, 2013 at 12:48 am
1) Included with the database backup and the all log backups that occur while it's running
2) Included with the database backup and the all log backups that occur while it's...
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
January 23, 2013 at 12:04 am
Cache store flush is not going to cause any problems with a restore. Other way around, restoring a database will flush the caches. It's not an error, just SQL notifying...
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
January 22, 2013 at 11:45 pm
Sean Lange (1/22/2013)
ScottPletcher (1/22/2013)
DiverKas (1/22/2013)
2) Do NOT let your DBA's design the database.
3) Hire a Data Architect.
Just saying. The first...
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
January 22, 2013 at 1:25 pm
LAW1143 (1/22/2013)
might this have anything to do with the datatypes of the index columns?
No. Nothing strange about bigint columns.
Just checking... You are rebuilding the same index that you're checking (same...
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
January 22, 2013 at 1:03 pm
Robert Davis (1/22/2013)
There must simply not be enough contiguous free space for it to rebuild it unfragmented.
I've seen indexes rebuild fragmented before, but never this bad.
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
January 22, 2013 at 12:29 pm
LAW1143 (1/22/2013)
its a link to my dropbox, but understand your hesitation. dont have another place handy to stick that image at the moment, so sorry...
btw, you can attach images...
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
January 22, 2013 at 12:27 pm
You have autoshrink on by any chance?
btw, you can attach images to the posts. I'm not clicking on an obfuscated link that could go anywhere.
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
January 22, 2013 at 12:21 pm
sqlfriends (1/22/2013)
for the 3 rd one, I usually...
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
January 22, 2013 at 11:28 am
Viewing 15 posts - 14,671 through 14,685 (of 49,552 total)