Viewing 15 posts - 19,351 through 19,365 (of 49,552 total)
If I run this test against MS Access or MySql it takes aprox. 4000ms.
bullo (4/4/2012)
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 4, 2012 at 12:28 pm
Lynn Pettis (4/3/2012)
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 4, 2012 at 12:23 pm
Anyone in the mood for a deadlock? Please? http://www.sqlservercentral.com/Forums/Topic1277697-1550-1.aspx
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 4, 2012 at 10:52 am
Mac1986 (4/4/2012)
When you asked for graph, were you referring to SQL Server Profiler graph?
No. Referring to the deadlock graph in the error log. The one you posted this morning,
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 4, 2012 at 10:51 am
Stefan Krzywicki (4/4/2012)
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 4, 2012 at 10:49 am
That's not going to do what you want.
That's the set of backup and restore statements you use if the data file has been damaged or lost. Not what you'd use...
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 4, 2012 at 10:46 am
Mac1986 (4/4/2012)
It looks like SPID 76,85 and 91 are suspended. Not sure what process is responsible for it. Is it SPID 25?
No. It's a deadlock, processes 76, 85 and 91...
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 4, 2012 at 10:01 am
Don't. Log shipping replaces your log backups with its own log backups.
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 4, 2012 at 9:37 am
As I said, has to do with bad coding and bad indexing.
Something like this is a trivial example:
DECLARE CURSOR FOR <select that returns 200 products>
WHILE <not end of cursor>
SELECT SUM(TotalOrdered)...
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 4, 2012 at 9:28 am
1. Yes, but it's not very useful. If the primary ever fails and you have to switch to the secondary, there will be no way to go back to 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
April 4, 2012 at 9:14 am
capn.hector (4/4/2012)
Lynn Pettis (4/4/2012)
GilaMonster (4/4/2012)
A new misspelling for my records...Thank you Linn and Gylla
Me too.
i always like the ones that thank my post count level thingy (ssc-whatever)
Yeah, that was fun...
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 4, 2012 at 9:10 am
tiago.palhota (4/4/2012)
In which situations a 2GB table could be read 1000times?
Many, many situations. Usually around poor coding or poor indexing.
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 4, 2012 at 9:08 am
p.s. I've seen single stored procedures with a logical IO of > 100 000 000 (1.4TB data) in a database that is 50GB in size
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 4, 2012 at 9:07 am
It's read a total of 2.8 TB of data from cache since it connected. That could be a 2GB table read 1000 times, it could be a 200 MB table...
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 4, 2012 at 8:56 am
Brandie Tarvin (4/4/2012)
Lynn Pettis (4/4/2012)
GilaMonster (4/4/2012)
A new misspelling for my records...Thank you Linn and Gylla
Me too.
I'm stealing these name spellings for a story. @=)
You guys wanna be villains, heroes, or...
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 4, 2012 at 7:53 am
Viewing 15 posts - 19,351 through 19,365 (of 49,552 total)