Viewing 15 posts - 1,921 through 1,935 (of 49,552 total)
darshan.joshi29 (12/28/2016)
5.sanity check of application with 2016 version database.
Testing should be the first thing done, in a dev/test environment, long before the production server is touched. If you test...
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 10, 2017 at 2:16 am
What's your concern with replication?
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 10, 2017 at 2:14 am
Mail the dev team and ask nicely. (not joking, this isn't something they've disclosed afaik)
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 9, 2017 at 9:19 am
Snargables (1/9/2017)
So when you say wrap around are u speaking of just the that column or all of them?
The sample_ms, the one you were asking about.
The other columns...
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 9, 2017 at 8:50 am
When you can remove the join hints and get us an execution plan, please post back. Until then, there's nothing we can really do with that query.
Nolock hints mean that...
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 9, 2017 at 8:40 am
FROM sys.tables WHERE name NOT IN (<list of tables to be excluded>);
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 9, 2017 at 7:44 am
Start by taking out the nolock hints (they allow the query to return incorrect data) and the join hints so that the optimiser is free to choose a good 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
January 9, 2017 at 7:40 am
Snargables (1/9/2017)
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 9, 2017 at 7:30 am
aalberyo (1/9/2017)
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 9, 2017 at 7:28 am
Uninstall the RC (hope that it uninstalls cleanly) and install the RTM. The RCs don't always support upgrades, especially not to the final release version.
Personally I install CTPs and RCs...
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 9, 2017 at 5:40 am
JasonClark (1/8/2017)
You may use this statement to check the virtual I/O file statesSELECT * FROM sys.dm_io_virtual_file_stats (NULL, NULL);
GO
This shows you how many I/Os occurred, with latencies for all the files.
Only...
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 9, 2017 at 5:36 am
http://sqlinthewild.co.za/index.php/2011/08/16/compiles-and-recompiles/
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 9, 2017 at 5:35 am
It's probably an execution plan change, possibly triggered by data volume changes.
Do you have any record of what the queries were running like before this?
Do you have...
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 6, 2017 at 6:35 am
The CXPacket wait is not a problem. sys.dm_exec_requests only shows thread 0 of a parallel query and, as I explained above, thread 0 is the controller thread. It will always...
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 6, 2017 at 6:09 am
Before we go on, what exactly are you declaring to be the issue?
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 6, 2017 at 4:46 am
Viewing 15 posts - 1,921 through 1,935 (of 49,552 total)