Re-boot is OK

Hi,
Rebooting is not a permanent solution.
Poor coding techniques & H/W resources not being planned
well for a SQL Box and Insufficient Hardware. Start
working on...
1. Application Tuning .
2. SQL Server Tuning ( not needed in most cases)
3. hardware Tuning
There is a good book from Microsoft press titled " SQL
Server 2000 Performance Tuning Tech Reference" by Whalen.
Also refer to Refer www.sql-server-performance.com . They
have loads of stuff on performance tuning.
HTH
Regards
THIRUMAL REDDY MARAM
Sys Admin / SQL DBA

quote:

---

>--Original Message--
>Does anyone know ehrn my SQL server is slow then I re-
>boot it. Onces I re-boot it, the SQL server performance
>become OK(normal). Does anyone know what is the problem
>and how to solve it.
>.
>

---

Hi,
During a problem situation do,
1. Use performance monitor to check the hardware usage,
1. CPU Usage
2. Memory Usage
3. Disk I/o
2. From query analyzer use sp_who to verify any blocked process.
3. Execute a select statment in sysprocess table to identify the
process/user using the resource
select substring(loginame,1,20) as login,cpu ,physical_io ,
memusage from sysprocesses
identify the user and execute a dbcc inputbuffer(spid) to check the
backend procedure / SQL he is executing.
Thanks
Hari
MCDBA
"Thirumal" <anonymous@.discussions.microsoft.com> wrote in message
news:115301c3df4b$ab6a0860$a601280a@.phx.gbl...[QUOTE]
> Hi,
> Rebooting is not a permanent solution.
> Poor coding techniques & H/W resources not being planned
> well for a SQL Box and Insufficient Hardware. Start
> working on...
> 1. Application Tuning .
> 2. SQL Server Tuning ( not needed in most cases)
> 3. hardware Tuning
> There is a good book from Microsoft press titled " SQL
> Server 2000 Performance Tuning Tech Reference" by Whalen.
> Also refer to Refer www.sql-server-performance.com . They
> have loads of stuff on performance tuning.
> HTH
> --
> Regards
> THIRUMAL REDDY MARAM
> Sys Admin / SQL DBA