SQL Server Performance

Search Results

Search Again
  1. ddbb

    Win2k SP4 installation on cluster

    Post by: ddbb, Nov 12, 2003 in forum: SQL Server Clustering
    That doc clearly states that pausing node and moving groups is enough for Win SP installation - so thanks for your help in confirming that; that is...
  2. ddbb

    Win2k SP4 installation on cluster

    Thread by: ddbb, Nov 12, 2003, 7 replies, in forum: SQL Server Clustering
    Is there any special requirement (or procedure) for installing Win2k SP4 on SQL2k failover cluster apart from pausing node and moving all groups to...
  3. ddbb

    node removed from cluster admin.

    Post by: ddbb, Nov 5, 2003 in forum: SQL Server Clustering
    Active node is on and working just fine. The problem is how will that node react on the SQL Setup in attempt to add new node (having in mind that...
  4. ddbb

    node removed from cluster admin.

    Post by: ddbb, Nov 5, 2003 in forum: SQL Server Clustering
    Unfortunately I won't be in the position to check the server till tomorrow. What approach would you suggest if there is no test environment? Thanks...
  5. ddbb

    node removed from cluster admin.

    Thread by: ddbb, Nov 5, 2003, 4 replies, in forum: SQL Server Clustering
    Hi,<br /><br />I have the following problem:<br /><br />Windows admin removed passive SQL Server 2000 cluster node without running SQL Server Setup...
  6. ddbb

    CPU stuck between 30 and 50 %

    Post by: ddbb, Oct 28, 2003 in forum: Performance Tuning for DBAs
    When you choose Reorganize data and index pages then Update statistics option is actually disabled. quote:Originally posted by LuisMartin...
  7. ddbb

    CPU stuck between 30 and 50 %

    Post by: ddbb, Oct 28, 2003 in forum: Performance Tuning for DBAs
    No Auto_Close, no Auto_Shrink. quote:Originally posted by satya Do you have any other database settings like Auto_Close or Auto_Shrink? _________...
  8. ddbb

    CPU stuck between 30 and 50 %

    Post by: ddbb, Oct 28, 2003 in forum: Performance Tuning for DBAs
    What I'm doing each night is running Data Maintenance Plan with option Reorganize data and index pages. So statistics are updated. quote:Originally...
  9. ddbb

    CPU stuck between 30 and 50 %

    Post by: ddbb, Oct 28, 2003 in forum: Performance Tuning for DBAs
    I have "Auto Update Statistics" database setting ON. Are you sugessting something in addition to that? Can you be more precise please? Thanks....
  10. ddbb

    CPU stuck between 30 and 50 %

    Post by: ddbb, Oct 28, 2003 in forum: Performance Tuning for DBAs
    automatic quote:Originally posted by LuisMartin How about Update Statistics? Luis Martin ...Thus mathematics may be defined as the subject in...
  11. ddbb

    CPU stuck between 30 and 50 %

    Post by: ddbb, Oct 28, 2003 in forum: Performance Tuning for DBAs
    indexes are recreated each night quote:Originally posted by satya Then DBCC DBREINDEX during less traffic on the database and check the...
  12. ddbb

    CPU stuck between 30 and 50 %

    Post by: ddbb, Oct 28, 2003 in forum: Performance Tuning for DBAs
    7.5GB quote:Originally posted by satya What is the size of database? _________ Satya SKJ Moderator SQL-Server-Performance.Com
  13. ddbb

    CPU stuck between 30 and 50 %

    Post by: ddbb, Oct 28, 2003 in forum: Performance Tuning for DBAs
    automatic off quote:Originally posted by LuisMartin Database Grow, is set automatic 10%?. If yes and Database is big, may be SQL has extra work to...
  14. ddbb

    CPU stuck between 30 and 50 %

    Post by: ddbb, Oct 28, 2003 in forum: Performance Tuning for DBAs
    0 allocation errors and 0 consistency errors quote:Originally posted by LuisMartin Why not DBCC DBcheck or checkalloc to see if there is some...
  15. ddbb

    CPU stuck between 30 and 50 %

    Post by: ddbb, Oct 28, 2003 in forum: Performance Tuning for DBAs
    No, server is dedicated to SQL and sqlservr.exe is the only process that takes resources. I haven't tried DBCC checks - what should I look for?...
  16. ddbb

    CPU stuck between 30 and 50 %

    Post by: ddbb, Oct 28, 2003 in forum: Performance Tuning for DBAs
    Which counter do you actually have in mind? Memory:Available Bytes is variable and is between 500MB and 1GB. Thanks for help quote:Originally...
  17. ddbb

    CPU stuck between 30 and 50 %

    Post by: ddbb, Oct 28, 2003 in forum: Performance Tuning for DBAs
    Disk usage is fine - avg. queue lenght is less than 0.1 and %disk time is 1.5%. quote:Originally posted by LuisMartin How about Disk usage during...
  18. ddbb

    CPU stuck between 30 and 50 %

    Post by: ddbb, Oct 28, 2003 in forum: Performance Tuning for DBAs
    Almost 1GB of RAM is still available, pages/sec on average < 20. SQL Server is set to use memory dynamically. quote:Originally posted by satya...
  19. ddbb

    CPU stuck between 30 and 50 %

    Thread by: ddbb, Oct 28, 2003, 32 replies, in forum: Performance Tuning for DBAs
    I have following configuration: 1. active/passive cluster, Win2000, SQL2000 2. 4 CPUs in each node, 4GB RAM in each node 3. Disk arrays configured...
Showing results 1 to 19 of 19
Search Again