Viewing 15 posts - 8,641 through 8,655 (of 49,552 total)
bugg (6/23/2014)
GilaMonster (6/23/2014)
The 0%, 0 seconds usually require a restart of SQL (not the server) to resolve. Otherwise wait.
Thanks Gila, when you say wait how long could that be before...
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
June 23, 2014 at 3:04 am
andrew gothard (6/23/2014)
GilaMonster (6/21/2014)
I love arguing this one with devs, so much 'agile' nonsense sometimes. 😀 "Creating validation in the database is a violation of the DRY principal"
The concept'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
June 23, 2014 at 3:01 am
The 0%, 0 seconds usually require a restart of SQL (not the server) to resolve. Otherwise wait.
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
June 23, 2014 at 2:34 am
rquest7 (6/22/2014)
What are the steps that a DBA or sql admin needs to do, to resolve the transaction log full issue
Did you bother to read the article I referenced?
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
June 23, 2014 at 2:33 am
This article appears to be an exact copy-paste of http://gavindraper.com/2012/02/18/sql-server-isolation-levels-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
June 23, 2014 at 2:29 am
Locks you take never prevent you from taking other locks. They prevent *other* sessions from taking incompatible locks.
Still doesn't explain why you have an unnecessary (slow, inefficient) cursor.
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
June 22, 2014 at 2:20 pm
Shrinking the file - DBCC ShrinkFile. Requires that there's actually free space in the file first, if there isn't you'll have to delete data.
Full transaction log - http://www.sqlservercentral.com/articles/Administration/64582/
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
June 22, 2014 at 2:18 pm
There's a 3rd party SSIS component that assigns sequential numbers to data in a task. Can you not use that instead, possibly with an SSIS sort. May be faster, may...
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
June 22, 2014 at 1:17 pm
geo123abram (6/22/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
June 22, 2014 at 10:17 am
You are never blocked by yourself. Any locks that you hold are compatible with other locks that you request, they only prevent other people from taking incompatible locks.
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
June 22, 2014 at 10:15 am
WolfgangE (6/22/2014)
Also, the DTA shows you suggestions for one specific query, I think.
That's the missing index DMVs. DTA can tune a workload. It's still very prone to over-suggesting indexes....
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
June 22, 2014 at 10:14 am
I would agree with Chris Date on that. Yes, it's up-front work, but in my opinion everything that can be validated in a DB should be.
I love arguing this...
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
June 21, 2014 at 8:09 am
There's no such thing as a correct value for that counter. There's normal for your system, and abnormal based on your baselines.
Monitor for a while, see what is normal for...
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
June 21, 2014 at 6:34 am
Mirroring creates an exact copy (mirror) of the database on the second instance. Everything in the database is kept completely in sync.
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
June 20, 2014 at 1:36 pm
The only 'normal' that counter has is 'normal for your system'. It's dependant on hardware, database (structure and size), workload and probably other factors.
Monitor for a while, see what 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
June 20, 2014 at 1:32 pm
Viewing 15 posts - 8,641 through 8,655 (of 49,552 total)