[dba-SQLServer] Optimizing Stored Procedures and Views

David,
  I might have missed your first post.  I'm curious to know what is
your server configuration like?, memory, hdd, raid, and of course...
index defrags.



On 4/2/06, David Emerson <newsgrps at dalyn.co.nz> wrote:
> Cross posted AccessD SQL
>
> SQL2000
>
> Another thing I have noticed - When I view task manager, the first
> programme fluctuates between 80-90% of the CPU usage, but when run on
> the second database (the one which takes so long to process) the CPU
> usage sits on 99%.
>
> Regards
>
> David Emerson
> Dalyn Software Ltd
> New Zealand
>
> _______________________________________________
> dba-SQLServer mailing list
> dba-SQLServer at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/dba-sqlserver
> http://www.databaseadvisors.com
>
>


--
-Francisco
http://pcthis.blogspot.com |PC news with out the jargon!
http://sqlthis.blogspot.com | Tsql and More...