Server Configuration
in [Microsoft SQL Server]
|
dm_db_index_operational_stats hangs on SQL Server 2005 (9.00.4294. We have a problem with dm_db_index_operational_stats in SQL Server 2005 (9.00.4294.00). When we run it with partition_id = 1 on a table which is non-partitioned SQL server dumps (non-yielding scheduler) and writes messages like following in the SQL Server log. Process 374:0:0 (0x10d0) Worker 0x00000000059621C0... 3 Jun 2010 03:30
tempdb CHECKPOINT It returns nothing , all empty, but still I have hight IO and CPU ... 3 Jun 2010 04:35
Get script from Maintenance Plans Hi, I take my backup, reorg, rebuild ... with Maintenance Plan I have to do this with scripts now. Is it possible to get scripts from Maintenance Plan SS2005-2008 Thanks in advance ... 2 Jun 2010 16:30
how to collect the data and log file growth trend in past in s Thank you guys. Just wonder any DMV records those information in sql server 2005/2008? Thanks. "Uri Dimant" wrote: Iter You can create a simple table and keep the log/data file size in per day, and then compare them late on "Iter" <Iter(a)discussions.microsoft.com> wrote in message news:... 2 Jun 2010 14:17
Maintenance plan in sql server 2008 management studio Hi, when I right mouse click on a certain maintenance plan and choose Modify, The follow error popped up in a dialogue box. --------------------------------------------------------------- Unexpected error: service 'Microsoft.VisualStudio.Designer.Interfaces.INVSDDesignerService' is not available. Make sur... 1 Jun 2010 20:51
SQL 2005 all the way to 2014 Our devs would like to stay on SQL 2005 all the way until 2014 or so.. They believe they will retire the app by then. What should we keep them informed about as far as the cons of that approach ? I understand mainstream support comes to an end next year... and we can go extended support ... What does that real... 4 Jun 2010 03:47
tempdb CHECKPOINT Hi Friends, SQL 2008 - I have high CPU and IO (4457218,1120635) count. it cause my disk queues to spike hight and disk %idle time to drop to almost %0. where should I look for it ? ( beside slow raid configuration on storage side ! which we are aware of it already) thanks in advance, Patirck ... 2 Jun 2010 04:25
Database Mirroring for large number of databases We have a SQL Server 2005 box in clustered environment. There is a requirement to copy databases (60 databases) to the remote SQL 2005 box at DR site. Looking at replication, log shipping and DB mirroring, DB mirroring seems to be a doable option. Any suggestion would be appreciated with regard to performance f... 4 Jun 2010 13:41
DeadLock Hi, in SQLSERVER 2005 , how to : Trace the Lock: Deadlock Chain event by using SQL Server Profiler Thanks. ... 1 Jun 2010 06:29 |