Viewing 15 posts - 106 through 120 (of 126 total)
since the correct final answer is impossible to say without IOPS, brand specs, etc. I'll say
Tempdb on ssd.
January 11, 2017 at 8:16 pm
20 seems high, but your real issue is the scans (as you already know).
Are the indexes and stats being created, maintained, reviewed and altered as appropriate?
January 11, 2017 at 2:22 pm
It totally depends on the IOPS of each storage, and your performance testing.
Have you allocated files properly for tempdb, etc?
January 11, 2017 at 1:59 pm
FWIW, if its a backup, it will typically end with .bak extension. For databases files, you will generally see an .mdf and an .ldf file for basic...
January 6, 2017 at 8:10 am
Can't speak to your issue directly, but a number of different sessions at PASS Summit this year pointed out that changing the compat level from 120 to 130 (or the...
December 30, 2016 at 11:59 am
Since the services are what you are really looking for, you will see all of them for each Server you query.
If you search for SQL Server Service on YourServer0546, which...
December 30, 2016 at 11:05 am
stepping back...since you've been troubleshooting for a week on three different sites, might I suggest either opening a case with MS, or re-initializing. The re-publishing thing will make...
December 30, 2016 at 9:58 am
It may sound a bit-self serving, but if you have a server list in a text file, you can loop through that quite easily using Lowells commands coupled with techniques...
December 30, 2016 at 7:55 am
SQL VM as noted above has two different ways to pay. You pay while the VM shows anything other than 'Deallocated' in the Azure Portal. Turn off...
December 30, 2016 at 7:46 am
As far as I've ever seen, the alignment is done in the presentation layer...Excel, SSRS, etc. SQL just pushes the data...
December 30, 2016 at 6:39 am
Sign up for the free/limited Azure account and start learning the Azure Portal, how to create a VM (with or without SQL preinstalled), how to create an Azure SQL Database,...
December 27, 2016 at 12:08 pm
Please explain what you mean by Replication (many use the term generically).
Microsoft Replication is built into SQL Server and will replicate to both another SQL Server as well as an...
November 22, 2016 at 6:06 am
First of all, DO NOT USE MAINTENANCE PLANS for any of this. Try what you find at the following URLhttps://ola.hallengren.com/[/url]
First of all, DO NOT USE MAINTENANCE PLANS for any of this. Try what you find at the following URL
There are situations where (not very flexible) maintenance...
November 18, 2016 at 2:13 pm
There are some limitations and such listed here:
SQL Server 2016 Support for SQL Server 2005
November 18, 2016 at 1:14 pm
Mainstream support for Windows 2008 R2 has ended, extended support in 2020...any chance you can build a cluster with current versions and migrate to that? Just a thought,...
October 19, 2015 at 8:43 am