Viewing 15 posts - 38,881 through 38,895 (of 49,552 total)
DBAs_worst_nightmare (5/27/2009)
What about the users / logins / roles and stuff if you use the detach / attach method ?
Exactly the same as if you use backup/restore.
Users and roles 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
May 27, 2009 at 1:42 am
I would guess that for the first query the index is covering and in the second (because it's a select *) it's not. With a covering index just the NC...
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
May 27, 2009 at 1:16 am
If you go with option 2, you must back the transaction log up after switching back to full. This is because you can't take tail log backups if the DB...
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
May 27, 2009 at 1:11 am
Did they say what RAID level? Or are we talking just 2 physical disks with no redundancy of any form?
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
May 26, 2009 at 4:17 pm
shruti.ratnagirish (5/26/2009)
ok. is there a way to see the queries for those transactions?
Not from the default trace. The SQL Batch/Statement start/complete events aren't there. The SP completed/started events aren't there.
You...
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
May 26, 2009 at 3:42 pm
Uncle Moki (5/26/2009)
So, I'm guessing that increasing the size of TempDB is not going to help?
Probably not, but make sure that TempDB's initial size is set to something...
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
May 26, 2009 at 3:03 pm
Uncle Moki (5/26/2009)
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
May 26, 2009 at 2:57 pm
Uncle Moki (5/26/2009)
I'm guessing that's not a good idea?
That's an understatement. With all the data files on one drive, all of the DBs are fighting over what's probably...
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
May 26, 2009 at 2:48 pm
Biggest one I've worked directly with hit 1.2 TB just before I left.
I'm curious. How will knowing what size DBs we've worked with help you in an interview?
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
May 26, 2009 at 2:03 pm
Uncle Moki (5/26/2009)
What's the layout of databases on LUNs?
The MDFs are all on "J". The LDFs are all on "P"...for the most part.
All of them? 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
May 26, 2009 at 2:00 pm
Probably IO contention.
What's the layout of databases on LUNs?
What's the RAID level on those LUNs
Are the dedicated or shared LUNs?
What do the perfmon counters Physical Disk: Avg sec/read, Avg...
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
May 26, 2009 at 1:43 pm
There's still two addresses and two phone numbers in the table. That could (or could not) be construed as repeating groups.
If it is considered a repeating group, this isn't even...
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
May 26, 2009 at 1:32 pm
middletree (5/26/2009)
So if I back up the lgos regularly, it will make the logs smaller?
More correct to say, if you backup the logs frequently the log shouldn't grow. A backup...
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
May 26, 2009 at 1:26 pm
What mode did you specify? If the mode is limited (which is the default) then quite a few of the columns will be null because the leaf pages of 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
May 26, 2009 at 1:07 pm
What's the full message of the error?
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
May 26, 2009 at 12:59 pm
Viewing 15 posts - 38,881 through 38,895 (of 49,552 total)