Viewing 15 posts - 16,876 through 16,890 (of 49,552 total)
Could you explain 'cannot connect' a little more? What happens? What errors? What investigation has been done?
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
August 28, 2012 at 5:02 pm
Sergiy (8/28/2012)
GilaMonster (8/28/2012)
(query processor doesn't work with pages, just rows)Sure?
Yes. Completely sure.
Ever heard of locks escalation?
Sure have. What's that got to do with the price of vegetables?
p.s. You do know...
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
August 28, 2012 at 4:30 pm
Sergiy (8/28/2012)
GilaMonster (8/28/2012)
http://www.simple-talk.com/books/sql-books/troubleshooting-sql-server-a-guide-for-the-accidental-dba/There's a good coverage of locking modes in chapter 6, including why SQL needs IX locks at higher levels.
So, what would be your explanation?
Well I wrote that portion...
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
August 28, 2012 at 4:27 pm
There's a good coverage of locking modes in chapter 6, including why SQL needs IX locks at higher levels.
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
August 28, 2012 at 2:56 pm
eric.lyons (8/28/2012)
GilaMonster (8/28/2012)
eric.lyons (8/28/2012)
8/19/2012 9:51spid25sCHECKDB for database 'Maint' finished without errors on 2012-08-19 03:14:55.117 (local time).
8/19/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
August 28, 2012 at 2:25 pm
eric.lyons (8/28/2012)
And yet, on a job interview I was very surprised to learn about the HOURS passing waiting for a VLDB to come on line because of dbcc.
I'd be very...
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
August 28, 2012 at 2:24 pm
Well, you can. You'd have to save the trace to a network location or ask your server admin to map a drive. Then you'd have to set permissions on your...
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
August 28, 2012 at 2:22 pm
eric.lyons (8/28/2012)
8/19/2012 9:51spid25sCHECKDB for database 'Maint' finished without errors on 2012-08-19 03:14:55.117 (local time).
8/19/2012 9:51spid36sCHECKDB 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
August 28, 2012 at 2:14 pm
eric.lyons (8/28/2012)
dbcc checkdb runs on startup. This is an issue for any VLDB. It particularly is bad for mirroring and cluster failovers.
No it does not. SQL does not...
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
August 28, 2012 at 2:11 pm
You don't need windows server rights. You can run the trace as the article shows, as long as SQL Server has rights to the location it'll work, you'll just have...
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
August 28, 2012 at 1:41 pm
I recommend you do not run the Profiler GUI against a busy production server. It's far more overhead than a server side trace.
Set up a server side trace, save 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
August 28, 2012 at 12:51 pm
Edit: Blah, blah, waffle, waffle.
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
August 28, 2012 at 10:41 am
Not weird at all. There's no need to sort as all rows match all rows with that join you've specified. Look at the join columns in the merge join ()...
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
August 28, 2012 at 10:19 am
Yes, a clustered index is the table (or the materialised view) and hence contains all columns at the leaf level as the actual data pages are found at the leaf.
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
August 28, 2012 at 10:12 am
Eric Stimpson (8/28/2012)
In my environ, dbcc table check occurs, I believe due to backup option "checksum" which causes a page checksum calculation on every table's data prior to backup.
Checksum 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
August 28, 2012 at 8:53 am
Viewing 15 posts - 16,876 through 16,890 (of 49,552 total)