Viewing 15 posts - 6,286 through 6,300 (of 49,552 total)
It's the stored proc.
Not uncommon for a dev server not to show performance issues that prod does. Dev typically has tiny data sets and a couple of users at most....
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
April 1, 2015 at 3:37 am
A timeout means that the procedure is running for longer than the application is willing to wait. You'll need to analyse the proc, identify the cause of the poor performance...
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
April 1, 2015 at 2:50 am
If that was my system, I'd start by looking at the execution plan and seeing if the index is optimal. Good chance it isn't.
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
March 31, 2015 at 1:07 pm
sqlfriends (3/30/2015)
If blocking is not the issue, what could it be?
Where did I say that blocking is not the issue?
It's lock-related waits, that's blocking by definition.
I said "the blocking process...
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
March 31, 2015 at 10:53 am
There isn't a threshold. A table which never gets updated could have stats 5 years old which are still good. A table which gets updated thousands of times a second...
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
March 31, 2015 at 7:59 am
stephen.long.1 (3/31/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
March 31, 2015 at 7:55 am
If you can figure out a computed column that will always be unique, using your requirements and probably the primary key, you can put a unique index on 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
March 31, 2015 at 7:52 am
Brandie Tarvin (3/31/2015)
GilaMonster (3/31/2015)
Nice attitude...if you had type this in the first place, then i would not have shouted... hehe
Thank you for your First informative reply.
Dare we ask which poster?
I'm...
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
March 31, 2015 at 7:51 am
Yet Another DBA (3/31/2015)
The "Most of those I have worked with " is based on experience and not some slapdash generalisation
Fair enough. 🙂
I think the majority of people I've worked...
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
March 31, 2015 at 6:41 am
Kris Gruttemeyer (3/30/2015)
Database 'Utilities' running the upgrade step from version 781 to...
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
March 31, 2015 at 5:43 am
Yet Another DBA (3/31/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
March 31, 2015 at 5:28 am
spaghettidba (3/31/2015)
GilaMonster (3/31/2015)
Not efficient as it prevents index seeks, not that a text column can have indexes, but I don't like teaching bad options.
Exactly my point: a bad option is...
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
March 31, 2015 at 5:20 am
DBA From The Cold (3/31/2015)
I don't think OR is supported in filtered indexes WHERE clause.
That's my recollection as well. Filtered indexes are nice in places, but they're still very...
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
March 31, 2015 at 4:35 am
spaghettidba (3/31/2015)
GilaMonster (3/31/2015)
Nice attitude...if you had type this in the first place, then i would not have shouted... hehe
Thank you for your First informative reply.
You're far too kind. I have...
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
March 31, 2015 at 4:34 am
You can detach/attach or you can use ALTER DATABASE ... MODIFY and then change the names of the files in the file system, same process as you'd use to move...
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
March 31, 2015 at 4:27 am
Viewing 15 posts - 6,286 through 6,300 (of 49,552 total)