Viewing 15 posts - 45,016 through 45,030 (of 49,552 total)
Ratheesh.K.Nair (8/15/2008)
I have a database having 1 mdf file,1 ndf file and 2 log...
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 15, 2008 at 6:24 am
Did you install one of the CTPs or the evaluation version? It should have said what version it was during the installation.
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 15, 2008 at 6:18 am
Take your trace file and look for the queries that overall take the longest and/or have the highest number of reads. Take those queries/procs and see if you can tune...
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 15, 2008 at 2:41 am
Considering that, I will recommend recreating the pk as a nonclustered index, and putting the clustered index on the three columns
[ValidationExceptionId]
[ValuationPoint]
[ValuationPointDate]
Since there are no queries using the PK to filter,...
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 15, 2008 at 2:26 am
Not unless you have an unbroken chain of transaction logs from the time of that full backup up until now.
You can't restore the backup, then switch some of the files...
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 15, 2008 at 1:15 am
Use explorer's search to see if you can find the missing file.
When you deleted the database (step 8) SQL went and deleted all the files that are part of...
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 15, 2008 at 12:19 am
Make sure that you've updated all the statistics on all the tables after the upgrade.
UPDATE STATISTICS < Table Name >
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 15, 2008 at 12:13 am
Don't think so. I think it's just the metadata and some statistics of the index. The DTA's got some undocumented tricks that it uses when it tests queries out.
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 15, 2008 at 12:09 am
As far as I'm aware, they are used by the Database Tuning Advisor to help it estimate the effect that an index would have on a query.
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 14, 2008 at 3:40 pm
Or upgrade to SQL Server 2008. It's built right into management studio.
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 14, 2008 at 3:32 pm
A what? Do you mean hypothetical 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
August 14, 2008 at 3:30 pm
K. Brian Kelley (8/14/2008)
It's expected that our time there be used to bring back knowledge for the whole team's benefit. Since I had my laptop with me, I basically...
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 14, 2008 at 3:23 pm
Perhaps in between the delete batches restart the log reader, let it process the deleted rows, then backup the log, disable the log reader, delete, repeat.
It's a lot of script...
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 14, 2008 at 3:07 pm
Larry Johnson (8/14/2008)
Thanks for your feedback!I get a little frustrated when someone asks for money to attend a conference, and all the bloggers can talk about are silly things.
I...
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 14, 2008 at 2:56 pm
Jeff Moden (8/14/2008)
Oh hell no! 🙂 I'm not a "systems" type of DBA
:hehe: Me neither
Thanks again for the help... I may have to make...
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 14, 2008 at 2:42 pm
Viewing 15 posts - 45,016 through 45,030 (of 49,552 total)