Viewing 15 posts - 36,706 through 36,720 (of 49,552 total)
Script or routine for what?
What maintenance are you doing on the log? Why is it so large (hint, see sys.databases for the log_reuse_wait_descr column for the reason). What recovery model?
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 31, 2009 at 3:33 am
I've worked with unpartitioned tables with over 150 million rows in. That's equivalent to 2 and a half months of your data. It's manageable and a few million is 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 31, 2009 at 3:32 am
That's odd. Must be something in the log that the backup needs, maybe an open transaction
Also, I have to ask, a 61 GB log file with a 560 MB data...
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 31, 2009 at 1:59 am
I understand what it is you want. What I'm curious about is why you want to see any one of the child rows. Usually for this kind of thing there'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
August 31, 2009 at 1:57 am
Integrity check has to read every single page in the database. That's going to read a lot from disk.
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 31, 2009 at 1:54 am
Do you have indexes to support the frequently run queries? Can the queries use those indexes?
2 million rows isn't that much. SQL can handle that with ease. If you're having...
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 31, 2009 at 1:54 am
Sumanta Roy (8/30/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
August 31, 2009 at 1:50 am
Sumanta Roy (8/30/2009)
I got one requirement to divide my tempdb data files into 8 files in sql server 2008. This is to improve the performance.
What's the reasoning behind 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 30, 2009 at 3:27 pm
Take the query from your first post and just remove the where clause. That will give you the fragmentation levels of all indexes in the entire server, regardless of page...
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 30, 2009 at 1:56 pm
Edit: Nevermind. Did like Jeff and commented before reading and read protect as in backup up, not protect as in secure.
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 30, 2009 at 1:42 pm
Smaller indexes tend not to defragment well, there'll often be fragmentation after the rebuild. Also, fragmentation's only an issue when doing large range scans of an index from disk. Small...
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 30, 2009 at 1:09 pm
gmamata7 (8/30/2009)
But, I have 22 databases. Is Having 22 steps for a Index reorganize/rebuild makes sense?
Why not?
Is there no way to make the script to work for all databases other...
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 30, 2009 at 1:07 pm
So it doesn't matter in the slightest which row you get back from the child table?
I must admit, that's a little odd.... Why is it that any one will do?
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 30, 2009 at 12:55 pm
Yes. The job history window reads from the MSDB database. There's only one place the logs are stored. Hence you'll get the same results from the query as from 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 30, 2009 at 11:10 am
Define 'first'. There's no order within a table in SQL so there has to be something that determines which row it is that you want. If you can explain that...
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 30, 2009 at 11:09 am
Viewing 15 posts - 36,706 through 36,720 (of 49,552 total)