Viewing 15 posts - 37,741 through 37,755 (of 49,552 total)
The remote timeout setting affects remote servers only. It has no effect on how long queries will wait on the local server.
If you want the alter database to kick everyone...
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
July 10, 2009 at 5:15 am
This is kinda what the beginning of the output looks like (this particular graph is 120 lines long in total)
[font="Courier New"]deadlock-list
deadlock victim=processf14c58
process-list
process id=processc8f198 taskpriority=0 logused=1120 waitresource=KEY:...
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
July 10, 2009 at 5:06 am
BU69 (7/10/2009)
I use trace flag 1204, doesn't 1222 give the results in xml?
1222 is not xml. It's the profiler event "Deadlock graph" that gives xml. The output of 1222...
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
July 10, 2009 at 3:57 am
Switch traceflag 1222 on. That will result in a deadlock graph been written to the error log every time a deadlock occurs. The graph will tell you, among other things,...
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
July 10, 2009 at 3:27 am
There is no SP4 for SQL 2005. There's an SP4 for SQL 2000, but the very latest for SQL 2005 is Service pack 3, cumulative update 4, released Jun 15...
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
July 10, 2009 at 3:24 am
sanderstad (7/10/2009)
The weird thing is that the logfile grows from 100MB to 45GB overnight.
There's some operation overnight that requires 45 GB or so of log space.
Rebuilding all indexes?
Doing large 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
July 10, 2009 at 12:45 am
Only after an unusual activity has grown the log beyond what is needed for normal database activity.
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
July 9, 2009 at 2:36 pm
Lamprey13 (7/9/2009)
Whitefang, is that you?
Don't think so. There's been no mention of "Enterprise Application" or "Entry level DBA" yet. 😀
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
July 9, 2009 at 2:09 pm
doug turner (7/9/2009)
After doing all that, I ran the backup with truncate_only, then the dbcc_shrink and it went down to 104K!
Now do a full backup, because you've just...
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
July 9, 2009 at 2:02 pm
Why do you want to shrink the log at all? You should manage the log so that the file size is adequate for the activity in your database and 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
July 9, 2009 at 1:53 pm
Juanita (7/9/2009)
I have an existing sql 2000 server that has a maintenance plan whose only step is to UPDATE STATISTICS on the OPTIMIZER tab. I also notice that all of...
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
July 9, 2009 at 1:27 pm
In that case, somehow you've got a half-set up transactional publication. I really wish I knew how this happened.
The fix is fairly simple. Create a transactional replication publication. Add 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
July 9, 2009 at 1:16 pm
Run sp_helppublication in the published database. In the results, the replication frequency will tell you what it is
Books Online
Type of replication frequency:
0 = Transactional
1 =...
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
July 9, 2009 at 12:49 pm
Duplicate post. No replies to this thread please. Direct replies to:http://www.sqlservercentral.com/Forums/Topic750337-145-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
July 9, 2009 at 12:18 pm
doug turner (7/9/2009)
If I remember correctly, the replication occurs once a day.
Transactional replication is constant. What kind of replication are you 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
July 9, 2009 at 12:14 pm
Viewing 15 posts - 37,741 through 37,755 (of 49,552 total)