Viewing 15 posts - 9,781 through 9,795 (of 49,552 total)
Please note: 12 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
March 7, 2014 at 1:41 am
Sqlsavy (3/6/2014)
thanks I updated stats using sp_updatestats and I also used sp_msforeachtable 'UPDATE STATISTICS ? WITH FULLSCAN' but i can still see the fragmenation as below
Update Stats doesn'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 7, 2014 at 1:39 am
You said earlier
Since there is no open transaction it should've been committed.
How did you identify that the session causing the blocking did not have an open transaction?
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 7, 2014 at 1:37 am
SQL Guy 1 (3/6/2014)
If nothing blocks his report, he does not need to care about held locks and open trans.
To diagnose blocking you need to investigate locks and 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
March 6, 2014 at 2:04 pm
Honesty, integrity, able to ask for help when they're stuck.
I don't expect someone to know everything, no one does. I do expect someone to be able to admit when they're...
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 6, 2014 at 1:58 pm
Locks are released either when the statement completes or when the transaction commits. The only way a sleeping connection can be holding a lock (other than the normal database lock)...
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 6, 2014 at 1:50 pm
Check for open transactions. If those sessions are starting transactions and no committing, their locks will be held until thye commit, rollback or disconnect.
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 6, 2014 at 6:08 am
The risk is that when the SSD fails, your SQL Server instance shuts down and you won't be able to restart it until you replace the SSD or move TempDB...
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 6, 2014 at 5:11 am
Unique indexes should never be considered unused as they are enforcing the uniqueness of the column(s).
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 6, 2014 at 5:05 am
Maybe this will be of some help: https://www.simple-talk.com/sql/performance/sql-server-deadlocks-by-example/
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 6, 2014 at 4:54 am
Grant Fritchey (3/6/2014)
MysteryJimbo (3/6/2014)
Koen Verbeeck (3/6/2014)
MysteryJimbo (3/6/2014)
Koen Verbeeck (3/5/2014)
Pfff, than you have never been in Belgium before 😀
If we wouldn't be having the most traffic jam congested cities in 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
March 6, 2014 at 4:43 am
Maybe. Is it performing inadequately? Do you have to filter on the expression or can you filter on the raw columns instead without returning incorrect results?
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 6, 2014 at 1:56 am
Other than mis-placed commas, reserved words as table names, the where clause 'problem' is solved by putting the expression in the where. General hint, don't use column names as alias...
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 6, 2014 at 1:34 am
I'd probably start with the Virtual File Stats DMV.
Good, acceptable and worse for IO volumes is completely dependent on your hardware and application, there's no universal figure for how many...
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 6, 2014 at 1:28 am
Jeff Moden (3/5/2014)
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 6, 2014 at 12:01 am
Viewing 15 posts - 9,781 through 9,795 (of 49,552 total)