Re: waittype=WRITELOG

Marek Wierzbicki (marek.wierzbickiiiii@xxxxxxxxxxxxx) writes:
I start do it from 2 weeks. After create indexes and join on indexed
fields is a little bit better. I will be looking for next havy queries
and optimize it.

Do you hear sth about
"periscope" - tolls for searching worst queries (or others such tools)? I
can't do it with profiler (all queries have zero execution time)

If all queries execute in zero time, then you must have a good system. :-)
What value are looking at Duration or CPU? Does StartTime and EndTime
agree with the zero-time?

You can look at http://www.sqldev.net/xp/xphrtimer.htm. This download
permits you install a DLL, so you can get millisecond resolution in
Profiler. With the standard time, you cannot get durations below 16 ms.

Then again, if your queries are that quick, it is not likely that you
can get that much information, even with a better timer.


--
Erland Sommarskog, SQL Server MVP, esquel@xxxxxxxxxxxxx

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx
.

Relevant Pages

  • Importance of Max Degree of Parallelism in SQL Server
    ... This setting can be changed at the server level by setting the value to 1, which will prevent parallel execution of all queries fired. ... thejami wrote: ... We have four processors on our SQL Server and want to turn on all four now ... parallelism" configuration option. ...
    (microsoft.public.sqlserver.server)
  • Re: The best elegant solution to override 65k rows limit in a sheet
    ... Access ships with MSDE.. ... >SQL Server Books Online (again-- Access ships with freeware SQL Server ... better ways to achieve their results through queries. ...
    (microsoft.public.excel)
  • Re: Official Status of SQLServer 2005 ADP
    ... solution might be to use ADP. ... With MDB and Linked tables, the only ways of accelerating things are the use ... of Views and the cumbersome use of SQL passthrough queries. ... > SQL Server, and carry on using Access like I aways had. ...
    (microsoft.public.access.adp.sqlserver)
  • Re: Sql server as back end
    ... There is an option in the Tools menu, Database Utilities, for Upsize to SQL Server. ... But after that, the queries should generally work, shouldn't they? ...
    (microsoft.public.access.tablesdbdesign)
  • Re: estimation the buffer cache hit ratio
    ... Now buffer cache hit ratio oscilate about 95-98. ... I would run Profiler and look for long-running queries. ... Erland Sommarskog, SQL Server MVP, esquel@xxxxxxxxxxxxx ... Books Online for SQL Server 2005 at ...
    (comp.databases.ms-sqlserver)