Viewing 15 posts - 43,441 through 43,455 (of 49,552 total)
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...
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
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
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
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...
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
October 30, 2008 at 1:27 am
Glad to hear it.
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
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,...
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
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...
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
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...
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
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?
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
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...
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
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...
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
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...
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
October 29, 2008 at 9:56 am
Duran (10/29/2008)
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
October 29, 2008 at 9:49 am
Can you post the entire error message please. SQL doesn't have a native error that refers to segmentation, so unless it's a user-defined error (error number > 50000), it's 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
October 29, 2008 at 9:42 am
You change the code so that it doesn't try to update the system tables. Then you run a checkDB to see how much mess there already is in the DB'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
October 29, 2008 at 9:40 am
You can set an end time when you create the trace. It's an optional parameter to the create trace proc.
What I typically do with the files is add 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
October 29, 2008 at 9:37 am
Viewing 15 posts - 43,441 through 43,455 (of 49,552 total)