Viewing 15 posts - 44,896 through 44,910 (of 49,552 total)
Download the AdventureWorks sample database. It's availuable on CodePlex
It's a relativly complex database with a fair bit of data in it.
Link goes tto the page with the SQL 2008 versions,...
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
August 23, 2008 at 4:49 am
Duplicate post.
Replies to the following thread please:
http://www.sqlservercentral.com/Forums/Topic557734-338-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
August 23, 2008 at 4:39 am
You can try reattaching the database. Depending on the corruption it might succeed.
Why no 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
August 23, 2008 at 4:32 am
Perfectly normal. Rebuilding indexes means putting all the leaf pages down in order. next to one another. If there isn't space available to do that, SQL will frow the 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
August 23, 2008 at 4:31 am
jfbergeron (8/22/2008)
See the attached pictures, since I cannot attach the plan itself... =(
You can zip the .sqlplan file and attach the zip.
Any table variables involved? User-defined functions (scalar or...
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
August 22, 2008 at 1:21 pm
Did you detach the database?
Can you reattach it?
Do you have a good 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
August 22, 2008 at 5:36 am
Arman (8/21/2008)
Please advise me that where i should replace, drop and put index.
I have absolutely no idea.
Indexes should be defined based on the queries that affect the tables. Without...
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
August 22, 2008 at 5:32 am
You can try them out on a test server and make sure that they are useful. Nothing else comes to mind.
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
August 21, 2008 at 12:19 pm
New_to_being_DBA (8/21/2008)
Also, I thought there was a correlation between avg_page_space_used_in_percent and avg_fragmentation_in_percent.
There isn't a direct relationship. The fragmentation % refers to the percentage of tables 'out of 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
August 21, 2008 at 12:03 pm
Run profiler during busy times, say for a hour. Monitor the T-SQL batch completed and the RPC:Completed.
Once the trace has finished, look through and find 5 or so queries...
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
August 21, 2008 at 11:56 am
It's because the table has a small number of pages. Don't worry too much about the fragmentation on small tables )less than about 100 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
August 21, 2008 at 11:14 am
Do you need redundancy on the drives? (ie, if a drive fails must the system continue working)?
If so, your best option is 3 RAID 1 (mirrored) arrays. It may 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
August 21, 2008 at 10:37 am
You may be better off monitoring that via perfmon. The os_performance_counters in the table version of all the counters that SQL Server exposes to perfmon. The counters are better explained...
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
August 21, 2008 at 7:33 am
Gut feel on this one it that (fk_websiteID, logdate) may be a good choice, though without seeing exec plans I can't say for sure.
Reason is that you say they are...
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
August 21, 2008 at 6:59 am
stephane3d (8/20/2008)
What's the golden rule of creating such clustered index for a log table?
In depends. < Ducks and runs >
Seriously, there aren't any hard and fast rules on...
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
August 21, 2008 at 6:51 am
Viewing 15 posts - 44,896 through 44,910 (of 49,552 total)