Viewing 15 posts - 43,456 through 43,470 (of 49,571 total)
The default trace is hard coded at 5 files. The only thing you can do with it is disable it.
I would suggest you set up your own trace. Put the...
October 30, 2008 at 3:50 am
Matt Miller (10/29/2008)
October 30, 2008 at 2:14 am
ALZDBA (10/30/2008)
GilaMonster (10/29/2008)
... SQL 2000? ...Indeed.
Try doing DBCC indexdefrag from time to to time on those 'no downtime' systems. It is an online operation.
This means that I'll only be...
October 30, 2008 at 2:09 am
Makarand Mohandas (10/29/2008)
Another option is try to backup of the tempdb before u try truncate it or shrink it.
You can't backup tempDB at all
Backup database tempdb to disk =...
October 30, 2008 at 1:44 am
If tempDB keeps growing to that size, it would indicate that it needs to be that size. Rather than keep on shrinking it (it will grow again), is there a...
October 30, 2008 at 1:40 am
Please don't cross post. It just wastes people's time and fragments replies.
No replies to this thread please. Direct replies to:
http://www.sqlservercentral.com/Forums/Topic594096-146-1.aspx
October 30, 2008 at 1:36 am
That queries the default trace. It's 5 files of 20 MB and when the 5'th fills up the 1st is deleted. The trace will only have data for a certain...
October 30, 2008 at 1:27 am
Glad to hear it.
October 30, 2008 at 1:24 am
Loner (10/29/2008)
In the maint plan, it did not do any re-org of data or index pages, update statistics or remove unused space, would it cause a problem?
No. It's TempDB,...
October 30, 2008 at 1:23 am
Simon_L (10/29/2008)
Gail did you change the file name by wrapping it in dynamic sql Im guessing
No. No need for that at all.
I put code like the following into a...
October 29, 2008 at 2:06 pm
ALZDBA (10/29/2008)
Some are not... as always ... no downtime allowed...:hehe: :ermm: :alien:
SQL 2000?
The final step on our rebuild jobs (no maint plans in use because ... well you know...
October 29, 2008 at 1:56 pm
Is the hardware of the two servers you're planning to cluster identical? Is the OS the same on both?
October 29, 2008 at 1:51 pm
Fragmentation's very different from segmentation which is what you initially posted.
Can you post the actual error you get, complete with all values? The list you gave vary from unimportant to...
October 29, 2008 at 1:50 pm
hydbadrose (10/29/2008)
what will be the problem you think?
No idea. There are far too many possibilities to say for certain.
Run profiler for a while, find the queries that are using...
October 29, 2008 at 1:48 pm
Are you sure that you didn't drop an index by accident?
Run profiler for a while, find the queries that are using the most cpu, run them and look at the...
October 29, 2008 at 9:56 am
Viewing 15 posts - 43,456 through 43,470 (of 49,571 total)