Viewing 15 posts - 2,191 through 2,205 (of 6,676 total)
What I see is that you have a single data file for tempdb - you should have more than that...how many will depend on a lot of factors, but you...
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
August 28, 2019 at 6:53 pm
Alerts will not cause any performance issues. Checking policies won't cause any performance issues.
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
August 28, 2019 at 2:17 am
There are a whole set of agent alerts that you can define for AG. I wrote the following script to add the alerts on my AOAG systems:
...
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
August 22, 2019 at 9:06 pm
Data Rat wrote:Thanks for your comment. But why would you use an inner join instead of a left join?
WHERE us.UserId = @userid
Because you've effectively turned the...
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
August 15, 2019 at 10:03 pm
I would not recommend that approach - combining discrete data elements into a single column will make it much harder to work with that data.
What is the purpose of combining...
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
August 15, 2019 at 8:09 pm
You need to validate the constraint connections between your tasks. For example - if you have a task to perform backups, and 2 separate tasks for notification, then one of...
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
August 15, 2019 at 7:38 pm
If you have the following - what do you want to do?
Employed = 'Staff', Non-Employed = 'Not Yet', Retired = 'Soon'
Or...
Employed = 'Soon', Non-Employed = 'Getting Hired', Retired = 'Long...
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
August 15, 2019 at 6:15 pm
That is by design - the password is stored 'securely' in the catalog, which means the connection manager dialog box will only allow you to overwrite the saved password.
Why would...
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
August 14, 2019 at 6:39 pm
It is not unexpected - it depends on what is processing at the time you look at the utilization. Temp tables do not retain data - once the connection is...
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
August 14, 2019 at 6:33 pm
Try running sp_configure without the reconfigure on your test instance - and see if the values from DBCC CONFIG actually change. My guess is that they won't change until a...
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
August 14, 2019 at 6:09 pm
One thing you stated that is of greater concern to me:
CPU hits max 60% most of the time so no big concerns there
I would say this is actually a...
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
August 13, 2019 at 7:29 pm
If you want to be able to list the latest file in a directory - you can use Powershell:
PS> dir | Select -Last 1
If there are other...
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
August 13, 2019 at 7:21 pm
Hi Alex,
Its is a full backup. Don't know the reason why , when backup is in progress , it was showing the backup file size as 822 GB but...
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
August 11, 2019 at 2:59 pm
You can go directly to the latest service pack - and I would also recommend applying the latest available CU for that service pack.
And yes - when applying to any...
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
August 9, 2019 at 6:07 pm
To move cluster resources to another node - you only need to issue Move-ClusterGroup. You don't need to suspend prior to moving the group...but you do have to issue the...
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
August 6, 2019 at 6:15 pm
Viewing 15 posts - 2,191 through 2,205 (of 6,676 total)