Viewing 15 posts - 11,371 through 11,385 (of 49,552 total)
Bhuvnesh (10/8/2013)
jasona.work (10/7/2013)
Somehow a value of '16923951 0' got entered...
while you insert value ( '16923951 0' ) into it.
it will throw error like "String , binary data would...
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
October 8, 2013 at 5:59 am
Jeff Moden (10/8/2013)
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
October 8, 2013 at 5:55 am
Again not what I was asking.
Are you seeing executing queries that are getting suspended with latch waits? Are these latch waits directly causing performance problems?
There will always be latch waits...
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
October 8, 2013 at 5:53 am
What if you're not using SSRS?
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
October 8, 2013 at 1:33 am
Jeff Moden (10/7/2013)
our NetOps guys are apparently using the quorum drive to transfer data to our warm DR site.
Oh my, that is horrid cluster design. Nothing but nothing should ever...
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
October 7, 2013 at 4:46 pm
Gerard Silveira (10/7/2013)
From Windows explorer the only directories I see are the MSCS and MSDTC, there is nothing else that I can see that could be steadily eating up the...
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
October 7, 2013 at 4:25 pm
Jeff Moden (10/7/2013)
GilaMonster (10/7/2013)
Jeff Moden (10/5/2013)
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
October 7, 2013 at 4:24 pm
babak3334000 (10/7/2013)
Just change the column name in all tables should be
The way you change column names in a table is with sp_rename. There's no command that automagically changes the column...
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
October 7, 2013 at 1:52 pm
Please note: 3 year old thread.
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
October 7, 2013 at 1:50 pm
No latch waits in that list, but that wasn't what I asked.
Have you seen queries executing that are suspended with latch waits? If so, what were the wait resources and...
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
October 7, 2013 at 12:02 pm
So for some reason the procedure's not committing the transactions that it starts, or it's starting within a transaction already. That means the locks are held until the connection 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
October 7, 2013 at 12:00 pm
Could the procedure's execution be leaving open transactions?
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
October 7, 2013 at 10:38 am
Problems as in noticeable slow queries due to latch waits, not a counter that's higher than some random person on the internet said it should be.
If so, what latches are...
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
October 7, 2013 at 10:34 am
First things first, are those latch waits causing problems?
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
October 7, 2013 at 10:26 am
thisted (10/7/2013)
It's almost like it is blocking itself.
One execution of the procedure can block other executions of the same procedure, but it's not blocking itself, there are different session IDs...
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
October 7, 2013 at 10:23 am
Viewing 15 posts - 11,371 through 11,385 (of 49,552 total)