Viewing 15 posts - 2,476 through 2,490 (of 49,552 total)
No where near enough information to be able to even start formulating a recommendation.
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
September 1, 2016 at 12:27 pm
I never said anything about the definition of expensive. In fact, I used the word only to give an idea of what a query cost is
If you mean the origin...
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
September 1, 2016 at 12:01 pm
What's the file name of the patch? What's the exact version of SQL Server on that machine (SELECT @@Version)?
Are there multiple instances on that server?
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
September 1, 2016 at 9:51 am
Depends how long a backup/restore takes, but
Last upgrade I did, three servers, the entire list of things you have there took less than 6 hours.
And that was about a 120GB...
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
September 1, 2016 at 8:09 am
The Dixie Flatline (9/1/2016)
Gail, does it have to do with things like parallel processing? Much higher CPU cost to get faster throughput?
Maybe, maybe not, no idea without seeing...
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
September 1, 2016 at 8:07 am
sqlbaby2 (9/1/2016)
what it mean by 'expensive' ? Can give some sample ?
What is needed (CPU, IO) to run the 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
September 1, 2016 at 8:05 am
You've got no testing phase, no time allocated to fix issues found. Upgrading to 2014 or beyond WILL have things that need fixing, due to the change to the cardinality...
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
September 1, 2016 at 8:00 am
It'll depend on how many things need fixing, anything from no effort to months of work.
Plan for a two-phase project. Test the system on SQL 2014, take note 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
September 1, 2016 at 7:04 am
I uploaded the slide-deck in progress. Comments?
http://www.sqlsaturday.com/554/Sessions/Details.aspx?sid=53948
I don't know who else (if anyone) is on the panel. Guess it'll be a surprise on the day.
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
September 1, 2016 at 6:09 am
A portion of the RANGE_ROWS, based on how far in to the interval SQL expects the specified predicate value to be, plus 16, the EQ_ROWS for the high key.
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
September 1, 2016 at 5:41 am
Not really. Cost is a measure of how expensive the query is, not how long it runs. A long time ago (~1995 or earlier), cost was calibrated as how long...
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
September 1, 2016 at 4:17 am
Don't shrink your DB. No need. SQL will reuse empty space within the file.
You can delete data that isn't needed (don't drop indexes, they may be needed for acceptable 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
September 1, 2016 at 3:40 am
You probably want to get more drive space in that case.
Databases grow, that's their nature.
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
September 1, 2016 at 1:43 am
So, I got roped into doing a professional development session for the local SQL Saturday.
"Becoming a successful SQL Developer"
Never done a professional development session before. Not sure how to approach...
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 31, 2016 at 2:49 pm
Run your rollback scripts.
If you don't have rollback scripts, then you're looking at restoring a copy of the database to a point before the deployment and then trying to synchronise...
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 31, 2016 at 2:45 pm
Viewing 15 posts - 2,476 through 2,490 (of 49,552 total)