Viewing 15 posts - 106 through 120 (of 127 total)
since the correct final answer is impossible to say without IOPS, brand specs, etc. I'll say
Tempdb on ssd.
There.
------------------------------------------------------------------------------------------------Standing in the gap between Consultant and ContractorKevin3NFDallasDBAs.com/BlogWhy is my SQL Log File HUGE?!?![/url]The future of the DBA role...[/url]SQL Security Model in Plain English[/url]
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?
------------------------------------------------------------------------------------------------Standing in the gap between Consultant and ContractorKevin3NFDallasDBAs.com/BlogWhy is my SQL Log File HUGE?!?![/url]The future of the DBA role...[/url]SQL Security Model in Plain English[/url]
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?
------------------------------------------------------------------------------------------------Standing in the gap between Consultant and ContractorKevin3NFDallasDBAs.com/BlogWhy is my SQL Log File HUGE?!?![/url]The future of the DBA role...[/url]SQL Security Model in Plain English[/url]
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...
------------------------------------------------------------------------------------------------Standing in the gap between Consultant and ContractorKevin3NFDallasDBAs.com/BlogWhy is my SQL Log File HUGE?!?![/url]The future of the DBA role...[/url]SQL Security Model in Plain English[/url]
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...
------------------------------------------------------------------------------------------------Standing in the gap between Consultant and ContractorKevin3NFDallasDBAs.com/BlogWhy is my SQL Log File HUGE?!?![/url]The future of the DBA role...[/url]SQL Security Model in Plain English[/url]
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...
------------------------------------------------------------------------------------------------Standing in the gap between Consultant and ContractorKevin3NFDallasDBAs.com/BlogWhy is my SQL Log File HUGE?!?![/url]The future of the DBA role...[/url]SQL Security Model in Plain English[/url]
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...
------------------------------------------------------------------------------------------------Standing in the gap between Consultant and ContractorKevin3NFDallasDBAs.com/BlogWhy is my SQL Log File HUGE?!?![/url]The future of the DBA role...[/url]SQL Security Model in Plain English[/url]
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...
------------------------------------------------------------------------------------------------Standing in the gap between Consultant and ContractorKevin3NFDallasDBAs.com/BlogWhy is my SQL Log File HUGE?!?![/url]The future of the DBA role...[/url]SQL Security Model in Plain English[/url]
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...
------------------------------------------------------------------------------------------------Standing in the gap between Consultant and ContractorKevin3NFDallasDBAs.com/BlogWhy is my SQL Log File HUGE?!?![/url]The future of the DBA role...[/url]SQL Security Model in Plain English[/url]
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...
------------------------------------------------------------------------------------------------Standing in the gap between Consultant and ContractorKevin3NFDallasDBAs.com/BlogWhy is my SQL Log File HUGE?!?![/url]The future of the DBA role...[/url]SQL Security Model in Plain English[/url]
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,...
------------------------------------------------------------------------------------------------Standing in the gap between Consultant and ContractorKevin3NFDallasDBAs.com/BlogWhy is my SQL Log File HUGE?!?![/url]The future of the DBA role...[/url]SQL Security Model in Plain English[/url]
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...
------------------------------------------------------------------------------------------------Standing in the gap between Consultant and ContractorKevin3NFDallasDBAs.com/BlogWhy is my SQL Log File HUGE?!?![/url]The future of the DBA role...[/url]SQL Security Model in Plain English[/url]
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 URL
ROFL :-D:-P;-):w00t::cool:
There are situations where (not very flexible) maintenance...
------------------------------------------------------------------------------------------------Standing in the gap between Consultant and ContractorKevin3NFDallasDBAs.com/BlogWhy is my SQL Log File HUGE?!?![/url]The future of the DBA role...[/url]SQL Security Model in Plain English[/url]
November 18, 2016 at 2:13 pm
There are some limitations and such listed here:
SQL Server 2016 Support for SQL Server 2005
------------------------------------------------------------------------------------------------Standing in the gap between Consultant and ContractorKevin3NFDallasDBAs.com/BlogWhy is my SQL Log File HUGE?!?![/url]The future of the DBA role...[/url]SQL Security Model in Plain English[/url]
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,...
------------------------------------------------------------------------------------------------Standing in the gap between Consultant and ContractorKevin3NFDallasDBAs.com/BlogWhy is my SQL Log File HUGE?!?![/url]The future of the DBA role...[/url]SQL Security Model in Plain English[/url]
October 19, 2015 at 8:43 am
Viewing 15 posts - 106 through 120 (of 127 total)