Viewing 15 posts - 43,606 through 43,620 (of 49,552 total)
Paula (10/23/2008)
When that happens it runs sp_reset_connection, which then turns auto update statistics off and back on again. It is apparently common with .NET Apps.
Reset connection is...
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 23, 2008 at 8:50 am
Some process or job is changing the database setting and enabling and disabling the feature. SQL won't by itself, change a database's settings.
You can run profiler for a while 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 23, 2008 at 8:24 am
It is on it's way and it is almost done. Can't say more, can't give a date.
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 23, 2008 at 8:01 am
Roust_m (10/23/2008)
I was under impression that every single DBCC command is now deprecated.
Some of them (showcontig, index defrag, etc) are deprecated, however there are a large number still...
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 23, 2008 at 7:58 am
Leo (10/22/2008)
According from your suggestion I have now change my some databases to SIMPLE Mode. I hope I don't need to worry about the log space anymore.
Nope. I suggested...
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 22, 2008 at 3:15 pm
It could be statistics, it could be poor indexes, it could be poorly written queries, it could be inadequate hardware. At the moment it looks like high CPU usage. Run...
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 22, 2008 at 12:49 pm
gavinparnaby (10/22/2008)
@Lynn
. You're essentially correct with your synopsis of the situation. Unfortunately my team consists of 2 + me while there are 20+ users each with multiple databases. I'm well...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 22, 2008 at 12:38 pm
Eugene (10/22/2008)
You need set 1204 in combination with the 3605 flag:
The output of the flag will be sent to the SQL Server error log whenever SQL Server encounters...
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 22, 2008 at 12:20 pm
victor_bosc (10/22/2008)
I am shrinking the files, because I think that the log’s size is increasing the backup times. What do you think?
Not likely. Backups are only concerned with the contents...
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 22, 2008 at 12:06 pm
victor_bosc (10/22/2008)
Optimization job, which rebuild indexes and shrink database files
Why?
I generally refer to that job setup as a complete waste of time. The rebuild indexes takes a lot of CPU,...
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 22, 2008 at 10:17 am
shavais (10/22/2008)
So I guess it comes with the client tools? Can I download just the client tools from somewhere?Thanks again for your help!
No, the client tools 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
October 22, 2008 at 10:09 am
Leo (10/22/2008)
I will change it to 75%.
How often are you backing up the transaction log?everynight.
Separate from the full backup?
Didn't we have a discussion on the transaction log in another thread...
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 22, 2008 at 10:07 am
Leo (10/22/2008)
The table size has nothing to do with the transaction log. If the transaction log is not huge, then it's not a transaction log problem.
Transaction Log...
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 22, 2008 at 8:31 am
What does SELECT @@version return?
DTA shouldn't be run from the server. It puts additional load on the server. For that matter, it shouldn't be run against a production server. 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 22, 2008 at 8:11 am
The table size has nothing to do with the transaction log. If the transaction log is not huge, then it's not a transaction log problem. You should not consider setting...
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 22, 2008 at 8:08 am
Viewing 15 posts - 43,606 through 43,620 (of 49,552 total)