Re: Slow File performance after SQL Server Install

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

From: Susan Bradley, CPA aka Ebitz - SBS Rocks [MVP] (sbradcpa_at_pacbell.net)
Date: 03/13/04 

Date: Sat, 13 Mar 2004 08:47:27 -0800

I have 2 gigs in my server at the office with dual processors. Watch
that performance counters and what not on the task manager... the only
time mine climbs is when I'm remoting into it.

What SuperG said...

Also what's the disk speed and what not... Steve F recommends a healthy
I/O as well there.

I think I would bite the bullet and call PSS... i think there's a driver
or something eating into that performance but I don't remember all the
tools to debug that.

James Reather wrote:

> "Susan Bradley, CPA aka Ebitz - SBS Rocks [MVP]" <sbradcpa@pacbell.net>
> wrote in message news:uWHtXBLCEHA.2560@TK2MSFTNGP12.phx.gbl...
>
>>512 isn't enough for SQL. 1 gig prob more like 2 gig.
>
>
> I'm not sure it's as simple as that. My server's got 1GB of RAM. It's got
> six network clients. Are you really telling me it needs more than 1GB of
> memory for SQL Server to work properly?
>
> ...and, out of genuine curiousity, have you tried this, or is it
> speculation? ;-)
>
> James
>
> 

-- 
http://www.sbslinks.com/really.htm

Relevant Pages

  • Re: PerfNet Error in Event Viewer
    ... This stopped the error message appearing ... but I still did not have a server service in Services ... Sharing for Microsoft Networks installed. ... service and I have since re-enabled the performance counters without any ...
    (microsoft.public.windowsxp.general)
  • RE: Repeatedly(Overwhelming) logged perfdisk warning event: 2001
    ... The server will run fine for about a week then the errors begin. ... reboot the server will run fine for another week. ... Disk performance counters can be enabled by using the Hardware ...
    (microsoft.public.win2000.advanced_server)
  • RE: ASP.NET performance counters not updating
    ... you found the performance counters for ASP.NET ... performance counters for ASP.NET applications. ... since you said that the counters on your 2003 server didn't list any of the ... Visit some of your ASP.NET web apps on the server so as to start them ...
    (microsoft.public.dotnet.framework.aspnet)
  • Re: HELP! high processor use by MAD monitor
    ... I have checked your option but that is not the problem, the Exchange ... Since my server has 15 minutes per hour that its stuck with full cpu ... > premmetje@zonnet.nl wrote: ... > Exchange Server 2003 performance counters are not seen in Windows ...
    (microsoft.public.exchange.admin)
  • Re: Slow File performance after SQL Server Install
    ... James Reather wrote: ... I get better performance running queries against MSDE on my ... > in to the server, the performance is still pretty poor. ...
    (microsoft.public.windows.server.sbs)