Re: Increasing Processor Utilization.

From: MZeeshan (mzeeshan_at_community.nospam)
Date: 02/08/05 

Date: Tue, 8 Feb 2005 15:03:01 -0800

Thanks for the response. We also have database that has grown to 80+ GB (120+
GB when fragmented). The RAM is not that high just 2 GB (with quad xeon
processors). The Fiber Array Channel we have can support upto 2 GB data rate
but I think in reality it won't be giving throughput of 1 GB.

Under those circumstances, the database creation alone takes 4 1/2 hours
with restoration taking around 4+ hours itself. Definitely, this is something
that I would like to improve.

If you were in my shoes, where would you be spending your money?

Thanks again!
MZ

"Mike Epprecht (SQL MVP)" wrote:

> Hi
>
> During those times, disk I/O is your bottleneck and not processors.
> It does not help throwing more processing power when the disk can't keep up.
>
> The only time I have wanted to see more CPU utilization was when I created a
> 100GB DB on an EMC SAN with 128GB cache (yes GB). The cache was keeping up
> with the server. Very few people has such a configuration.
>
> There is nothing you can configure, except ensuring that your disk subsystem
> is running optimally.
>
> Regards
> --------------------------------
> Mike Epprecht, Microsoft SQL Server MVP
> Zurich, Switzerland
>
> IM: mike@epprecht.net
>
> MVP Program: http://www.microsoft.com/mvp
>
> Blog: http://www.msmvps.com/epprecht/
>
> "MZeeshan" <mzeeshan@community.nospam> wrote in message
> news:7780C0C4-05F7-4F84-A13F-F7D50F772B8D@microsoft.com...
> > Hello-
> >
> > We are using SQL 2000/sp3a on both Windows 2000/2003 server environments.
> > All SQL Server boxes are dedicated environments.
> >
> > The question I have is based on personal observation. During intense
> > database activity like database creation, backup/restore and/or index
> > rebuilds, if there is a Quad processor machine, only 1 out of 4 processors
> > has higher activity while other three remain fairly unutilized.
> >
> > Is it possible if we can do like some OS configuration changes (???) to
> > increase processor utilization (out of other 3). Can we start extra
> database
> > threads using the any other processor?
> >
> > Please let me know.
> >
> > --
> > Regards,
> > MZeeshan
>
>
>

Relevant Pages

  • Re: % Disk Time
    ... Avg and current Disk queues instead. ... > I have separate drives each SQL Server database: ... > then your SQL Server ... >> Is not a very reliable indicator of an IO bottleneck. ...
    (microsoft.public.sqlserver.server)
  • Re: Server stops responding
    ... you may want to track your database with SQL Server Profiler to see if some processes takes longer then they should take. ... Physical Disk: % Disk Time (seperately for your OS and database disks, ...
    (microsoft.public.sqlserver.clients)
  • Re: 2 million records
    ... first point, its not a datawarehousing question, but a general SQL Server ... question & Web Developper question. ... second is not relevant to fine tune your database. ... Look at the avg disk queue length perf counter, ...
    (microsoft.public.sqlserver.datawarehouse)
  • Re: SQL Server Issues ::: ( how to avoid this issues )
    ... The file sizehave all the info you need for DISK REINIT. ... Log pages where SQL Server expects data pages is automatically handled over time. ... Or just transfer the stuff into a new database. ... >>> You guys are thinking just in the higher level of IT security policies... ...
    (microsoft.public.sqlserver.server)
  • Re: Error 823
    ... Regards. ... Microsoft SQL Server Storage Engine ... > I cannot extract much data out of the database and I can't view the most ... The problem is in the .MDF file, ...
    (microsoft.public.sqlserver.tools)