Viewing 15 posts - 4,066 through 4,080 (of 49,552 total)
Jeff Moden (12/5/2015)
vsamantha35 (12/3/2015)
•No of physical cpus= 2•no of logical cpu count = 24
I'm thinking that the logical to physical CPU ratio on that box is the real...
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
December 8, 2015 at 2:03 am
Fandy08 (12/7/2015)
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
December 8, 2015 at 2:01 am
Jason A. Long (12/7/2015)
If I were a betting man, I'd put my $$$ on Jacob being correct
You don't have to bet. From the OP:
SELECT FeedName ,
'Missing FileTableDB Record - External...
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
December 8, 2015 at 1:56 am
anthonymendozajr (12/7/2015)
This is a little concerning for me and I am curious if anyone super smart knows why???
Because it's perfectly legit SQL, syntatically valid. The fact that it's not 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
December 8, 2015 at 1:55 am
And it will only do anything if the cause of the full log really is replication. Plus, it'll break transactional replication and require that the subscriptions be reinitialised and it'll...
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
December 8, 2015 at 1:50 am
What's the lock escalation set to for the partitioned indexes?
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
December 7, 2015 at 7:10 am
What's the logic there? What is it that defines that the first row listed there must come 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
December 7, 2015 at 6:59 am
Updating every column's going to make update triggers more complex, as you now can't use IF UPDATE(... or similar, as every column will return true.
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
December 7, 2015 at 6:58 am
Ed Wagner (12/4/2015)
A SELECT TOP 1...ORDER BY would also do the trick.
Not necessarily. RowNumber can do grouping, and so return one row per partition. Top 1 is just top 1.
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
December 7, 2015 at 3:53 am
Yes, that would have updated all index stats. Probably resulted in the optimiser realising there was more data than it had previously thought (due to stale stats) and so changing...
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
December 7, 2015 at 3:51 am
mastersql (12/5/2015)
Hardware information: the server is a new Windows 2008 32 bit with a maximum ram installed 4GB
Just on this point.
My 2-year old laptop has more memory than that, you're...
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
December 7, 2015 at 3:51 am
Scalar functions are slow. What probably happened is that the execution plan changed and as a result the function was being run many more times.
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
December 5, 2015 at 1:43 pm
Don't 'prove it's a san issue'. Go sit with the SAN admins and debug this together. Pull the IO latency stats from the server and go and sit with them...
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
December 5, 2015 at 1:41 pm
KILL <session ID>
However do that and it will roll back, and roll back usually takes longer than the operation had up to that point. So kill an index rebuild that'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
December 5, 2015 at 1:38 pm
Tablediff works. Custom scripts. Redgate's SQLDataCompare.
Better to test comprehensively before the upgrade and not end up in a state where you have to revert. Identify all the breaking changes before...
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
December 4, 2015 at 12:28 pm
Viewing 15 posts - 4,066 through 4,080 (of 49,552 total)