Viewing 15 posts - 5,896 through 5,910 (of 49,552 total)
fedbn (5/18/2015)
GilaMonster (5/18/2015)
fedbn (5/18/2015)
Is it acceptable to disconnect all users a couple times an hour?On production? Is not possible.
No, on the reporting server. Is it acceptable to disconnect all users...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
May 18, 2015 at 8:44 am
Table definitions, index definitions and execution plan please.
Why do you think the sort is a problem?
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
May 18, 2015 at 8:43 am
audiocool (5/18/2015)
Check the activity monitor and found out there is a dead lock happened. Kill the process and it run again.
If it was a deadlock, you wouldn't have needed...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
May 18, 2015 at 8:41 am
fedbn (5/18/2015)
Is it acceptable to disconnect all users a couple times an hour?On production? Is not possible.
No, on the reporting server. Is it acceptable to disconnect all users every hour,...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
May 18, 2015 at 7:51 am
How often are log backups taken on production?
How far behind is the reporting database allowed to be?
Is it acceptable to disconnect all users a couple times an hour?
Can the reporting...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
May 18, 2015 at 7:32 am
Almighty (5/18/2015)
Adjust the max memory of sql server to 80 % of total memory and so that you wont face the issue again
If you look at his original post, his...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
May 18, 2015 at 6:58 am
audiocool (5/18/2015)
Sorry we don't have DBA here and everything learn from internet. 🙂
Which is why I'm very strongly suggesting you get a 3rd party in. There are lots of good...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
May 18, 2015 at 4:06 am
audiocool (5/18/2015)
No need to manage SQL Server 2000.
That, unfortunately, is the core of the problem. SQL Server has never been a 'does not need maintenance' system.
Could be any number of...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
May 18, 2015 at 3:31 am
Shawn Melton (5/17/2015)
Truthfully, I would get support from company or consultant that is familiar with performance tuning and troubleshooting.
To be honest, I second this. If there's no one there who...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
May 18, 2015 at 2:33 am
Furthermore the distributor has to be the highest version present in the topology, so the distributor will have to be on a SQL 2014 instance.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
May 18, 2015 at 1:26 am
TomThomson (5/17/2015)
That's a change which I think the customer should have recognised
Why? When the system has several thousand users, how could we possibly expect the customer's representative to know that...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
May 18, 2015 at 1:19 am
Jeff Moden (5/16/2015)
GilaMonster (5/15/2015)
David Webb-CDS (5/15/2015)
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
May 17, 2015 at 8:20 am
Eirikur Eiriksson (5/16/2015)
GilaMonster (5/16/2015)
Eirikur Eiriksson (5/16/2015)
a) SQL Server 2008 is a rather old product, consider SQL Server 2014 or 2016 as that will already give you some advantage.Um....
Point being...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
May 16, 2015 at 4:11 pm
Eirikur Eiriksson (5/16/2015)
a) SQL Server 2008 is a rather old product, consider SQL Server 2014 or 2016 as that will already give you some advantage.
Um....
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
May 16, 2015 at 3:30 pm
Jeff Moden (5/15/2015)
afw (5/15/2015)
Aah, makes sense. But boy was I getting that wrong...Thank you once again 🙂 🙂
My Dad has a saying about such things.
"Half of what is written...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
May 16, 2015 at 3:28 pm
Viewing 15 posts - 5,896 through 5,910 (of 49,552 total)