Viewing 15 posts - 61 through 75 (of 1,341 total)
I am looking to export data from SQL 2019 to sql 2017. What if the tables have primary key and foreign key relationship how would be the export is...
October 22, 2020 at 11:27 am
I am a newbie to SQL Server administration and config. Apologies if I appear to confuse/mix terminologies here.
I am trying to find a way to take a snapshot...
October 22, 2020 at 8:43 am
I was working on with requirement to load balance the traffic coming from application to secondary SQL Server replicas in an Always on Availability group. Read-only routing refers to...
October 22, 2020 at 8:31 am
Thanks! Sorry I wasn't clear, windows cluster is already configured. So I am looking to find how many more IP's is needed for install and configuring for SQL Server...
October 22, 2020 at 8:25 am
Mainly you need to look for what's using memory in such a way that the pages will be flushed. Again, if everything else is fine, this is probably just...
October 11, 2020 at 8:01 am
And you're seeing exactly why PLE is a horrible measure, standing on it's own. In combination with other measures, it may tell you things. Just PLE, nope....
October 11, 2020 at 8:00 am
And you're seeing exactly why PLE is a horrible measure, standing on it's own. In combination with other measures, it may tell you things. Just PLE, nope. No real...
October 8, 2020 at 5:05 am
I would start by down loading Glenn Berry s diagnostic queries and running these.
With page life expectancy, look at the long term trend. See Jonathan Kehayias blog about it...
October 8, 2020 at 4:55 am
Sorry I am not sure what you are asking. The case statement you show has two options - 'replicated' or 'not replicated' so I don't understand when you would...
October 6, 2020 at 6:21 am
I cannot see how <blocking-process> stands on the way of <blocked-process>.
Both queries apply shared locks, so, they should not block each other.
Can you find what is waitresource in the...
August 10, 2020 at 5:23 am
I cannot see how <blocking-process> stands on the way of <blocked-process>.
Both queries apply shared locks, so, they should not block each other.
Can you find what is waitresource in the...
August 10, 2020 at 4:51 am
Are they part of larger batches? There could be multiple statements involved.
Yes Grant that what we found when ran the profiler trace many transaction with same spid but after...
August 5, 2020 at 7:59 am
You've identified some queries, but now you need to investigate their behavior within the system. The way to do this is to look at the execution plan in order...
August 4, 2020 at 12:50 pm
Can you explain "We have 3 node in which 2 are SQL Cluster and 3rd one is Always On AG".?
But let's assume you have a 3 node AwalysON AG,...
August 4, 2020 at 8:16 am
can you try creating two server with SQL 2019 in same windows cluster add them to AOAG. Create replicas in new servers and failover to SQL 2019 and then remove...
July 1, 2020 at 7:42 am
Viewing 15 posts - 61 through 75 (of 1,341 total)