Viewing 15 posts - 4,606 through 4,620 (of 49,552 total)
If you're running under read committed snapshot, then why the nolock hint?
Under read committed snapshot, read queries don't take locks anyway, so all the nolock is doing is adding...
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 6, 2015 at 6:09 am
Commands do not undo themselves!
Either your original update didn't actually update any rows, or some other process was explicitly updating the data back. SQL will not randomly undo data...
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 6, 2015 at 4:18 am
There's nothing wrong with the update you posted, and providing there are rows with someField = 'OldValue', it'll work fine and doesn't need to be changed. Now if there 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 6, 2015 at 3:59 am
Probably not. It might even make the locking worse, as there will be less IO-related waits.
Buffer cache hit ratio's useless. A server can be under severe, sustained memory pressure 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 6, 2015 at 3:58 am
Implicit conversions most likely. Also they're much larger data types than you need. A GUID stored in a nvarchar column will take 72 bytes, vs 16 if stored in a...
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 6, 2015 at 3:56 am
No. Insufficient permissions will get you an error.
If you're sure there's no transaction (and that implicit transactions isn't on), then either someone else is running an update to reverse it,...
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 6, 2015 at 3:44 am
Either you're running the update in a transaction and not committing it, or someone else is running updates to reverse the changes, or someone's restoring the database from a backup.
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 6, 2015 at 3:29 am
I'd go instead with https://www.simple-talk.com/sql/performance/finding-the-causes-of-poor-performance-in-sql-server,-part-1/
Eirikur's query will show individual queries with high CPU usage, but by using just that you may miss the queries which are running very, very frequently.
Which...
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 6, 2015 at 2:52 am
Welsh Corgi (10/5/2015)
I have 1 Table has been refreshed since the 29th of October.I checked other tables and they are being refreshed.
How can I identify and correct the problem?
Considering 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
October 5, 2015 at 3:31 pm
Jeff Moden (10/5/2015)
Just curious as to why you wouldn't shrink it to zero and regrow it properly.
Huh? I said 'don't shrink it to zero', as in don't DBCC SHRINKFILE (2,0),...
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 5, 2015 at 3:18 pm
No.
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 5, 2015 at 3:06 pm
yb751 (10/5/2015)
The upcoming 'Stretch Database' feature in SQL 2016 may be exactly what you are looking for.
With poor queries, that'll just make matters worse. If the queries can't eliminate...
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 5, 2015 at 9:00 am
ps_vbdev (10/5/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
October 5, 2015 at 8:42 am
Please post the most common queries.
Also, why Datetimeoffset? It's not a common data type choice, especially since it's not daylight savings aware, which reduces the usefulness of storing a time...
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 5, 2015 at 7:30 am
ps_vbdev (10/5/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
October 5, 2015 at 6:55 am
Viewing 15 posts - 4,606 through 4,620 (of 49,552 total)