Viewing 15 posts - 1 through 15 (of 40 total)
Yes, our environment is a very large OLTP/Decision ecosystem that requires all index rebuilds to be 'online'. All our testing was performed with online index rebuilds.
April 12, 2017 at 2:20 pm
Updated information:
April 11, 2017 at 9:08 am
Have you considered attach? Would be cleaner solution due to the actual maintenance window.
Basic steps:
1. Shut down SQL Services
2.Copy entire directory of database/ transaction log onto new...
March 23, 2017 at 8:48 am
Yes, Identity columns().
Can't switch to GUID's... Too many tables and too much code.
For sequences - would need to define with specific data center indicator.
February 8, 2016 at 8:12 am
Yes, can leverage 256 (cores) across XX amount of blades.
There isn't much information about the server running SQL Server.
Simply wondering if anyone has experience with the server(s).
January 25, 2016 at 2:35 pm
It's a very volatile OLTP environment, with many, many IUD's happening throughout the day.
I'm trying to estimate (by executing a script, if one exists) that size of individual diff backups...
December 15, 2015 at 2:48 pm
Great question - server is huge.
80 cores, 1 TB RAM, FusionIO cards (Flash) for all storage.
Unfortunately, hardware isn't the issue.
March 26, 2014 at 9:17 am
Has anyone experienced this issue with large log generation?
I've been working with Microsoft since January - Long story short, we haven't received a fix yet...
Directly from Microsoft:
Issue 1 –...
July 25, 2013 at 6:20 am
We tried all sorts of fixes, including contacting Microsoft. Microsoft did not provide any feedback.
Finally - we executed the following in order...
DBCC FREEPROCCACHE
EXEC sp_recompile 'dbo.StoredProcedureName' (we preformed sp_recompile for...
September 25, 2012 at 8:46 am
1. No - no third party applications even installed on the server. All extended events are disabled.
2. Always On Availablility Group configured.
September 10, 2012 at 2:22 pm
Truthfully, I never found a solution. I've increased the setting size in the SQL Agent w/out much success.
Would really like to know how to view the history, but right now,...
September 10, 2012 at 1:55 pm
Hi -
I updated the values yesterday.
I set Max job history log size (in rows) to 3000 and Max job history rows per job to 1000.
I will update the values again...
August 24, 2012 at 7:26 am
Hi Guys -
Thanks for the responses...
Product version: 11.0.2325.0
Microsoft SQL Server Management Studio11.0.2100.60
For that Job name when I run sp_help_jobhistory, the result set is 0 records.
----------
Yes, I installed and running the...
August 23, 2012 at 2:56 pm
Now I need to go thru the our license process - which we did in March. 🙁
Really - If you're upgrading to sql 2012, read this:
August 8, 2012 at 11:07 pm
Hi -
Apologies for being unclear.
We perform hourly transaction log backups. And full backups daily.
So - if a full backup is taken at 9:00 can the 10:00 hourly transaction log backups...
August 1, 2012 at 8:07 am
Viewing 15 posts - 1 through 15 (of 40 total)