Hi, I have a database is read only purpose. But for some reasons, from
yesterday, the log file is growing to 10 GB.
How to find it out what cause the problem? Please help.One thing is the purpose and another the options of the db. See "alter
database" in BOL, to learn how to change a db to read_only mode.
Example:
use master
go
alter database northwind
set read_only
go
use northwind
go
select * into t1 from orders
go
use master
go
alter database northwind
set read_write
go
AMB
"js" wrote:
> Hi, I have a database is read only purpose. But for some reasons, from
> yesterday, the log file is growing to 10 GB.
> How to find it out what cause the problem? Please help.
>
>|||You could use Profiler to see what SQL statements are running in the
database. If the database is read-only then can you explicitly mark the
database as read-only? Also check the recovery model of your database. If
there is no need to write to that database, you could set the recovery model
to simple and make full database backups.
--
HTH,
Vyas, MVP (SQL Server)
SQL Server Articles and Code Samples @. http://vyaskn.tripod.com/
"js" <js@.someone@.hotmail.com> wrote in message
news:upLwwzDbFHA.2768@.tk2msftngp13.phx.gbl...
Hi, I have a database is read only purpose. But for some reasons, from
yesterday, the log file is growing to 10 GB.
How to find it out what cause the problem? Please help.|||Thanks for the help.
Is it possible to track down when the problem happened?
"Narayana Vyas Kondreddi" <answer_me@.hotmail.com> wrote in message
news:e5Emx$DbFHA.2984@.TK2MSFTNGP15.phx.gbl...
> You could use Profiler to see what SQL statements are running in the
> database. If the database is read-only then can you explicitly mark the
> database as read-only? Also check the recovery model of your database. If
> there is no need to write to that database, you could set the recovery
> model
> to simple and make full database backups.
> --
> HTH,
> Vyas, MVP (SQL Server)
> SQL Server Articles and Code Samples @. http://vyaskn.tripod.com/
>
> "js" <js@.someone@.hotmail.com> wrote in message
> news:upLwwzDbFHA.2768@.tk2msftngp13.phx.gbl...
> Hi, I have a database is read only purpose. But for some reasons, from
> yesterday, the log file is growing to 10 GB.
> How to find it out what cause the problem? Please help.
>
>|||Difficult. But if you could get hold of a tool like Lumigent Log Explorer,
you could look at the transaction log contents to identify any data
modification command that could have used up a lot of log space.
--
HTH,
Vyas, MVP (SQL Server)
SQL Server Articles and Code Samples @. http://vyaskn.tripod.com/
"js" <js@.someone@.hotmail.com> wrote in message
news:Ov5l9EEbFHA.3120@.TK2MSFTNGP12.phx.gbl...
Thanks for the help.
Is it possible to track down when the problem happened?
"Narayana Vyas Kondreddi" <answer_me@.hotmail.com> wrote in message
news:e5Emx$DbFHA.2984@.TK2MSFTNGP15.phx.gbl...
> You could use Profiler to see what SQL statements are running in the
> database. If the database is read-only then can you explicitly mark the
> database as read-only? Also check the recovery model of your database. If
> there is no need to write to that database, you could set the recovery
> model
> to simple and make full database backups.
> --
> HTH,
> Vyas, MVP (SQL Server)
> SQL Server Articles and Code Samples @. http://vyaskn.tripod.com/
>
> "js" <js@.someone@.hotmail.com> wrote in message
> news:upLwwzDbFHA.2768@.tk2msftngp13.phx.gbl...
> Hi, I have a database is read only purpose. But for some reasons, from
> yesterday, the log file is growing to 10 GB.
> How to find it out what cause the problem? Please help.
>
>|||Hi,
It is very difficult to investigate the real cause of the issue apart from
analyzing the transaction log.
Since your database is only Read only why dont you set the database itself
to READ ONLY mode.
ALTER DATABASE <DBNAME> SET READ_ONLY
Thanks
Hari
SQL Server MVP
"js" <js@.someone@.hotmail.com> wrote in message
news:upLwwzDbFHA.2768@.tk2msftngp13.phx.gbl...
> Hi, I have a database is read only purpose. But for some reasons, from
> yesterday, the log file is growing to 10 GB.
> How to find it out what cause the problem? Please help.
>
Showing posts with label purpose. Show all posts
Showing posts with label purpose. Show all posts
Friday, March 9, 2012
log file
Hi, I have a database is read only purpose. But for some reasons, from
yesterday, the log file is growing to 10 GB.
How to find it out what cause the problem? Please help.
One thing is the purpose and another the options of the db. See "alter
database" in BOL, to learn how to change a db to read_only mode.
Example:
use master
go
alter database northwind
set read_only
go
use northwind
go
select * into t1 from orders
go
use master
go
alter database northwind
set read_write
go
AMB
"js" wrote:
> Hi, I have a database is read only purpose. But for some reasons, from
> yesterday, the log file is growing to 10 GB.
> How to find it out what cause the problem? Please help.
>
>
|||You could use Profiler to see what SQL statements are running in the
database. If the database is read-only then can you explicitly mark the
database as read-only? Also check the recovery model of your database. If
there is no need to write to that database, you could set the recovery model
to simple and make full database backups.
HTH,
Vyas, MVP (SQL Server)
SQL Server Articles and Code Samples @. http://vyaskn.tripod.com/
"js" <js@.someone@.hotmail.com> wrote in message
news:upLwwzDbFHA.2768@.tk2msftngp13.phx.gbl...
Hi, I have a database is read only purpose. But for some reasons, from
yesterday, the log file is growing to 10 GB.
How to find it out what cause the problem? Please help.
|||Thanks for the help.
Is it possible to track down when the problem happened?
"Narayana Vyas Kondreddi" <answer_me@.hotmail.com> wrote in message
news:e5Emx$DbFHA.2984@.TK2MSFTNGP15.phx.gbl...
> You could use Profiler to see what SQL statements are running in the
> database. If the database is read-only then can you explicitly mark the
> database as read-only? Also check the recovery model of your database. If
> there is no need to write to that database, you could set the recovery
> model
> to simple and make full database backups.
> --
> HTH,
> Vyas, MVP (SQL Server)
> SQL Server Articles and Code Samples @. http://vyaskn.tripod.com/
>
> "js" <js@.someone@.hotmail.com> wrote in message
> news:upLwwzDbFHA.2768@.tk2msftngp13.phx.gbl...
> Hi, I have a database is read only purpose. But for some reasons, from
> yesterday, the log file is growing to 10 GB.
> How to find it out what cause the problem? Please help.
>
>
|||Difficult. But if you could get hold of a tool like Lumigent Log Explorer,
you could look at the transaction log contents to identify any data
modification command that could have used up a lot of log space.
HTH,
Vyas, MVP (SQL Server)
SQL Server Articles and Code Samples @. http://vyaskn.tripod.com/
"js" <js@.someone@.hotmail.com> wrote in message
news:Ov5l9EEbFHA.3120@.TK2MSFTNGP12.phx.gbl...
Thanks for the help.
Is it possible to track down when the problem happened?
"Narayana Vyas Kondreddi" <answer_me@.hotmail.com> wrote in message
news:e5Emx$DbFHA.2984@.TK2MSFTNGP15.phx.gbl...
> You could use Profiler to see what SQL statements are running in the
> database. If the database is read-only then can you explicitly mark the
> database as read-only? Also check the recovery model of your database. If
> there is no need to write to that database, you could set the recovery
> model
> to simple and make full database backups.
> --
> HTH,
> Vyas, MVP (SQL Server)
> SQL Server Articles and Code Samples @. http://vyaskn.tripod.com/
>
> "js" <js@.someone@.hotmail.com> wrote in message
> news:upLwwzDbFHA.2768@.tk2msftngp13.phx.gbl...
> Hi, I have a database is read only purpose. But for some reasons, from
> yesterday, the log file is growing to 10 GB.
> How to find it out what cause the problem? Please help.
>
>
|||Hi,
It is very difficult to investigate the real cause of the issue apart from
analyzing the transaction log.
Since your database is only Read only why dont you set the database itself
to READ ONLY mode.
ALTER DATABASE <DBNAME> SET READ_ONLY
Thanks
Hari
SQL Server MVP
"js" <js@.someone@.hotmail.com> wrote in message
news:upLwwzDbFHA.2768@.tk2msftngp13.phx.gbl...
> Hi, I have a database is read only purpose. But for some reasons, from
> yesterday, the log file is growing to 10 GB.
> How to find it out what cause the problem? Please help.
>
yesterday, the log file is growing to 10 GB.
How to find it out what cause the problem? Please help.
One thing is the purpose and another the options of the db. See "alter
database" in BOL, to learn how to change a db to read_only mode.
Example:
use master
go
alter database northwind
set read_only
go
use northwind
go
select * into t1 from orders
go
use master
go
alter database northwind
set read_write
go
AMB
"js" wrote:
> Hi, I have a database is read only purpose. But for some reasons, from
> yesterday, the log file is growing to 10 GB.
> How to find it out what cause the problem? Please help.
>
>
|||You could use Profiler to see what SQL statements are running in the
database. If the database is read-only then can you explicitly mark the
database as read-only? Also check the recovery model of your database. If
there is no need to write to that database, you could set the recovery model
to simple and make full database backups.
HTH,
Vyas, MVP (SQL Server)
SQL Server Articles and Code Samples @. http://vyaskn.tripod.com/
"js" <js@.someone@.hotmail.com> wrote in message
news:upLwwzDbFHA.2768@.tk2msftngp13.phx.gbl...
Hi, I have a database is read only purpose. But for some reasons, from
yesterday, the log file is growing to 10 GB.
How to find it out what cause the problem? Please help.
|||Thanks for the help.
Is it possible to track down when the problem happened?
"Narayana Vyas Kondreddi" <answer_me@.hotmail.com> wrote in message
news:e5Emx$DbFHA.2984@.TK2MSFTNGP15.phx.gbl...
> You could use Profiler to see what SQL statements are running in the
> database. If the database is read-only then can you explicitly mark the
> database as read-only? Also check the recovery model of your database. If
> there is no need to write to that database, you could set the recovery
> model
> to simple and make full database backups.
> --
> HTH,
> Vyas, MVP (SQL Server)
> SQL Server Articles and Code Samples @. http://vyaskn.tripod.com/
>
> "js" <js@.someone@.hotmail.com> wrote in message
> news:upLwwzDbFHA.2768@.tk2msftngp13.phx.gbl...
> Hi, I have a database is read only purpose. But for some reasons, from
> yesterday, the log file is growing to 10 GB.
> How to find it out what cause the problem? Please help.
>
>
|||Difficult. But if you could get hold of a tool like Lumigent Log Explorer,
you could look at the transaction log contents to identify any data
modification command that could have used up a lot of log space.
HTH,
Vyas, MVP (SQL Server)
SQL Server Articles and Code Samples @. http://vyaskn.tripod.com/
"js" <js@.someone@.hotmail.com> wrote in message
news:Ov5l9EEbFHA.3120@.TK2MSFTNGP12.phx.gbl...
Thanks for the help.
Is it possible to track down when the problem happened?
"Narayana Vyas Kondreddi" <answer_me@.hotmail.com> wrote in message
news:e5Emx$DbFHA.2984@.TK2MSFTNGP15.phx.gbl...
> You could use Profiler to see what SQL statements are running in the
> database. If the database is read-only then can you explicitly mark the
> database as read-only? Also check the recovery model of your database. If
> there is no need to write to that database, you could set the recovery
> model
> to simple and make full database backups.
> --
> HTH,
> Vyas, MVP (SQL Server)
> SQL Server Articles and Code Samples @. http://vyaskn.tripod.com/
>
> "js" <js@.someone@.hotmail.com> wrote in message
> news:upLwwzDbFHA.2768@.tk2msftngp13.phx.gbl...
> Hi, I have a database is read only purpose. But for some reasons, from
> yesterday, the log file is growing to 10 GB.
> How to find it out what cause the problem? Please help.
>
>
|||Hi,
It is very difficult to investigate the real cause of the issue apart from
analyzing the transaction log.
Since your database is only Read only why dont you set the database itself
to READ ONLY mode.
ALTER DATABASE <DBNAME> SET READ_ONLY
Thanks
Hari
SQL Server MVP
"js" <js@.someone@.hotmail.com> wrote in message
news:upLwwzDbFHA.2768@.tk2msftngp13.phx.gbl...
> Hi, I have a database is read only purpose. But for some reasons, from
> yesterday, the log file is growing to 10 GB.
> How to find it out what cause the problem? Please help.
>
log file
Hi, I have a database is read only purpose. But for some reasons, from
yesterday, the log file is growing to 10 GB.
How to find it out what cause the problem? Please help.One thing is the purpose and another the options of the db. See "alter
database" in BOL, to learn how to change a db to read_only mode.
Example:
use master
go
alter database northwind
set read_only
go
use northwind
go
select * into t1 from orders
go
use master
go
alter database northwind
set read_write
go
AMB
"js" wrote:
> Hi, I have a database is read only purpose. But for some reasons, from
> yesterday, the log file is growing to 10 GB.
> How to find it out what cause the problem? Please help.
>
>|||You could use Profiler to see what SQL statements are running in the
database. If the database is read-only then can you explicitly mark the
database as read-only? Also check the recovery model of your database. If
there is no need to write to that database, you could set the recovery model
to simple and make full database backups.
--
HTH,
Vyas, MVP (SQL Server)
SQL Server Articles and Code Samples @. http://vyaskn.tripod.com/
"js" <js@.someone@.hotmail.com> wrote in message
news:upLwwzDbFHA.2768@.tk2msftngp13.phx.gbl...
Hi, I have a database is read only purpose. But for some reasons, from
yesterday, the log file is growing to 10 GB.
How to find it out what cause the problem? Please help.|||Thanks for the help.
Is it possible to track down when the problem happened?
"Narayana Vyas Kondreddi" <answer_me@.hotmail.com> wrote in message
news:e5Emx$DbFHA.2984@.TK2MSFTNGP15.phx.gbl...
> You could use Profiler to see what SQL statements are running in the
> database. If the database is read-only then can you explicitly mark the
> database as read-only? Also check the recovery model of your database. If
> there is no need to write to that database, you could set the recovery
> model
> to simple and make full database backups.
> --
> HTH,
> Vyas, MVP (SQL Server)
> SQL Server Articles and Code Samples @. http://vyaskn.tripod.com/
>
> "js" <js@.someone@.hotmail.com> wrote in message
> news:upLwwzDbFHA.2768@.tk2msftngp13.phx.gbl...
> Hi, I have a database is read only purpose. But for some reasons, from
> yesterday, the log file is growing to 10 GB.
> How to find it out what cause the problem? Please help.
>
>|||Difficult. But if you could get hold of a tool like Lumigent Log Explorer,
you could look at the transaction log contents to identify any data
modification command that could have used up a lot of log space.
--
HTH,
Vyas, MVP (SQL Server)
SQL Server Articles and Code Samples @. http://vyaskn.tripod.com/
"js" <js@.someone@.hotmail.com> wrote in message
news:Ov5l9EEbFHA.3120@.TK2MSFTNGP12.phx.gbl...
Thanks for the help.
Is it possible to track down when the problem happened?
"Narayana Vyas Kondreddi" <answer_me@.hotmail.com> wrote in message
news:e5Emx$DbFHA.2984@.TK2MSFTNGP15.phx.gbl...
> You could use Profiler to see what SQL statements are running in the
> database. If the database is read-only then can you explicitly mark the
> database as read-only? Also check the recovery model of your database. If
> there is no need to write to that database, you could set the recovery
> model
> to simple and make full database backups.
> --
> HTH,
> Vyas, MVP (SQL Server)
> SQL Server Articles and Code Samples @. http://vyaskn.tripod.com/
>
> "js" <js@.someone@.hotmail.com> wrote in message
> news:upLwwzDbFHA.2768@.tk2msftngp13.phx.gbl...
> Hi, I have a database is read only purpose. But for some reasons, from
> yesterday, the log file is growing to 10 GB.
> How to find it out what cause the problem? Please help.
>
>|||Hi,
It is very difficult to investigate the real cause of the issue apart from
analyzing the transaction log.
Since your database is only Read only why dont you set the database itself
to READ ONLY mode.
ALTER DATABASE <DBNAME> SET READ_ONLY
Thanks
Hari
SQL Server MVP
"js" <js@.someone@.hotmail.com> wrote in message
news:upLwwzDbFHA.2768@.tk2msftngp13.phx.gbl...
> Hi, I have a database is read only purpose. But for some reasons, from
> yesterday, the log file is growing to 10 GB.
> How to find it out what cause the problem? Please help.
>
yesterday, the log file is growing to 10 GB.
How to find it out what cause the problem? Please help.One thing is the purpose and another the options of the db. See "alter
database" in BOL, to learn how to change a db to read_only mode.
Example:
use master
go
alter database northwind
set read_only
go
use northwind
go
select * into t1 from orders
go
use master
go
alter database northwind
set read_write
go
AMB
"js" wrote:
> Hi, I have a database is read only purpose. But for some reasons, from
> yesterday, the log file is growing to 10 GB.
> How to find it out what cause the problem? Please help.
>
>|||You could use Profiler to see what SQL statements are running in the
database. If the database is read-only then can you explicitly mark the
database as read-only? Also check the recovery model of your database. If
there is no need to write to that database, you could set the recovery model
to simple and make full database backups.
--
HTH,
Vyas, MVP (SQL Server)
SQL Server Articles and Code Samples @. http://vyaskn.tripod.com/
"js" <js@.someone@.hotmail.com> wrote in message
news:upLwwzDbFHA.2768@.tk2msftngp13.phx.gbl...
Hi, I have a database is read only purpose. But for some reasons, from
yesterday, the log file is growing to 10 GB.
How to find it out what cause the problem? Please help.|||Thanks for the help.
Is it possible to track down when the problem happened?
"Narayana Vyas Kondreddi" <answer_me@.hotmail.com> wrote in message
news:e5Emx$DbFHA.2984@.TK2MSFTNGP15.phx.gbl...
> You could use Profiler to see what SQL statements are running in the
> database. If the database is read-only then can you explicitly mark the
> database as read-only? Also check the recovery model of your database. If
> there is no need to write to that database, you could set the recovery
> model
> to simple and make full database backups.
> --
> HTH,
> Vyas, MVP (SQL Server)
> SQL Server Articles and Code Samples @. http://vyaskn.tripod.com/
>
> "js" <js@.someone@.hotmail.com> wrote in message
> news:upLwwzDbFHA.2768@.tk2msftngp13.phx.gbl...
> Hi, I have a database is read only purpose. But for some reasons, from
> yesterday, the log file is growing to 10 GB.
> How to find it out what cause the problem? Please help.
>
>|||Difficult. But if you could get hold of a tool like Lumigent Log Explorer,
you could look at the transaction log contents to identify any data
modification command that could have used up a lot of log space.
--
HTH,
Vyas, MVP (SQL Server)
SQL Server Articles and Code Samples @. http://vyaskn.tripod.com/
"js" <js@.someone@.hotmail.com> wrote in message
news:Ov5l9EEbFHA.3120@.TK2MSFTNGP12.phx.gbl...
Thanks for the help.
Is it possible to track down when the problem happened?
"Narayana Vyas Kondreddi" <answer_me@.hotmail.com> wrote in message
news:e5Emx$DbFHA.2984@.TK2MSFTNGP15.phx.gbl...
> You could use Profiler to see what SQL statements are running in the
> database. If the database is read-only then can you explicitly mark the
> database as read-only? Also check the recovery model of your database. If
> there is no need to write to that database, you could set the recovery
> model
> to simple and make full database backups.
> --
> HTH,
> Vyas, MVP (SQL Server)
> SQL Server Articles and Code Samples @. http://vyaskn.tripod.com/
>
> "js" <js@.someone@.hotmail.com> wrote in message
> news:upLwwzDbFHA.2768@.tk2msftngp13.phx.gbl...
> Hi, I have a database is read only purpose. But for some reasons, from
> yesterday, the log file is growing to 10 GB.
> How to find it out what cause the problem? Please help.
>
>|||Hi,
It is very difficult to investigate the real cause of the issue apart from
analyzing the transaction log.
Since your database is only Read only why dont you set the database itself
to READ ONLY mode.
ALTER DATABASE <DBNAME> SET READ_ONLY
Thanks
Hari
SQL Server MVP
"js" <js@.someone@.hotmail.com> wrote in message
news:upLwwzDbFHA.2768@.tk2msftngp13.phx.gbl...
> Hi, I have a database is read only purpose. But for some reasons, from
> yesterday, the log file is growing to 10 GB.
> How to find it out what cause the problem? Please help.
>
Wednesday, March 7, 2012
Log Cache Hit Ratio
Hi,
What would be the optimum percentage for the Log Cache Hit
Ratio?
Does this indicator at all have any purpose or
implications?
Thanks,
OskarI have never found a situation where that counter provided anything
useful... It has the same meaning as the data cache hit ratio, but applies
to log reads from the log cache.. ( I am not aware of any method to
configure the log cache either...)
Is your log cache hit ratio < 90%'
Wayne Snyder, MCDBA, SQL Server MVP
Mariner, Charlotte, NC
www.mariner-usa.com
(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org
"Oskar" <anonymous@.discussions.microsoft.com> wrote in message
news:1d8c01c4b752$e8163fb0$a501280a@.phx.gbl...
> Hi,
> What would be the optimum percentage for the Log Cache Hit
> Ratio?
> Does this indicator at all have any purpose or
> implications?
> --
> Thanks,
> Oskar|||Hi Wayne,
Yup, constantly at 50 %.
Wondering what this could mean and is it OK or not.
By the way I have SQL Server: Cache Manager: Cache Hit
Ratio steady at 70%.
Thanks,
Oskar
>--Original Message--
>I have never found a situation where that counter
provided anything
>useful... It has the same meaning as the data cache hit
ratio, but applies
>to log reads from the log cache.. ( I am not aware of any
method to
>configure the log cache either...)
>Is your log cache hit ratio < 90%'
>
>--
>Wayne Snyder, MCDBA, SQL Server MVP
>Mariner, Charlotte, NC
>www.mariner-usa.com
>(Please respond only to the newsgroups.)
>I support the Professional Association of SQL Server
(PASS) and it's
>community of SQL Server professionals.
>www.sqlpass.org
>"Oskar" <anonymous@.discussions.microsoft.com> wrote in
message
>news:1d8c01c4b752$e8163fb0$a501280a@.phx.gbl...
Hit[vbcol=seagreen]
>
>.
>|||Wayne,
I've never bother with this counter much at all? What is it really
measuring? Rollbacks? Reading from inserted/deleted tables in triggers?
Brian
"Wayne Snyder" <wayne.nospam.snyder@.mariner-usa.com> wrote in message
news:evKwbO2tEHA.3476@.TK2MSFTNGP14.phx.gbl...
> I have never found a situation where that counter provided anything
> useful... It has the same meaning as the data cache hit ratio, but applies
> to log reads from the log cache.. ( I am not aware of any method to
> configure the log cache either...)
> Is your log cache hit ratio < 90%'
>
> --
> Wayne Snyder, MCDBA, SQL Server MVP
> Mariner, Charlotte, NC
> www.mariner-usa.com
> (Please respond only to the newsgroups.)
> I support the Professional Association of SQL Server (PASS) and it's
> community of SQL Server professionals.
> www.sqlpass.org
> "Oskar" <anonymous@.discussions.microsoft.com> wrote in message
> news:1d8c01c4b752$e8163fb0$a501280a@.phx.gbl...
>
What would be the optimum percentage for the Log Cache Hit
Ratio?
Does this indicator at all have any purpose or
implications?
Thanks,
OskarI have never found a situation where that counter provided anything
useful... It has the same meaning as the data cache hit ratio, but applies
to log reads from the log cache.. ( I am not aware of any method to
configure the log cache either...)
Is your log cache hit ratio < 90%'
Wayne Snyder, MCDBA, SQL Server MVP
Mariner, Charlotte, NC
www.mariner-usa.com
(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org
"Oskar" <anonymous@.discussions.microsoft.com> wrote in message
news:1d8c01c4b752$e8163fb0$a501280a@.phx.gbl...
> Hi,
> What would be the optimum percentage for the Log Cache Hit
> Ratio?
> Does this indicator at all have any purpose or
> implications?
> --
> Thanks,
> Oskar|||Hi Wayne,
Yup, constantly at 50 %.
Wondering what this could mean and is it OK or not.
By the way I have SQL Server: Cache Manager: Cache Hit
Ratio steady at 70%.
Thanks,
Oskar
>--Original Message--
>I have never found a situation where that counter
provided anything
>useful... It has the same meaning as the data cache hit
ratio, but applies
>to log reads from the log cache.. ( I am not aware of any
method to
>configure the log cache either...)
>Is your log cache hit ratio < 90%'
>
>--
>Wayne Snyder, MCDBA, SQL Server MVP
>Mariner, Charlotte, NC
>www.mariner-usa.com
>(Please respond only to the newsgroups.)
>I support the Professional Association of SQL Server
(PASS) and it's
>community of SQL Server professionals.
>www.sqlpass.org
>"Oskar" <anonymous@.discussions.microsoft.com> wrote in
message
>news:1d8c01c4b752$e8163fb0$a501280a@.phx.gbl...
Hit[vbcol=seagreen]
>
>.
>|||Wayne,
I've never bother with this counter much at all? What is it really
measuring? Rollbacks? Reading from inserted/deleted tables in triggers?
Brian
"Wayne Snyder" <wayne.nospam.snyder@.mariner-usa.com> wrote in message
news:evKwbO2tEHA.3476@.TK2MSFTNGP14.phx.gbl...
> I have never found a situation where that counter provided anything
> useful... It has the same meaning as the data cache hit ratio, but applies
> to log reads from the log cache.. ( I am not aware of any method to
> configure the log cache either...)
> Is your log cache hit ratio < 90%'
>
> --
> Wayne Snyder, MCDBA, SQL Server MVP
> Mariner, Charlotte, NC
> www.mariner-usa.com
> (Please respond only to the newsgroups.)
> I support the Professional Association of SQL Server (PASS) and it's
> community of SQL Server professionals.
> www.sqlpass.org
> "Oskar" <anonymous@.discussions.microsoft.com> wrote in message
> news:1d8c01c4b752$e8163fb0$a501280a@.phx.gbl...
>
Log Cache Hit Ratio
Hi,
What would be the optimum percentage for the Log Cache Hit
Ratio?
Does this indicator at all have any purpose or
implications?
Thanks,
Oskar
I have never found a situation where that counter provided anything
useful... It has the same meaning as the data cache hit ratio, but applies
to log reads from the log cache.. ( I am not aware of any method to
configure the log cache either...)
Is your log cache hit ratio < 90%?
Wayne Snyder, MCDBA, SQL Server MVP
Mariner, Charlotte, NC
www.mariner-usa.com
(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org
"Oskar" <anonymous@.discussions.microsoft.com> wrote in message
news:1d8c01c4b752$e8163fb0$a501280a@.phx.gbl...
> Hi,
> What would be the optimum percentage for the Log Cache Hit
> Ratio?
> Does this indicator at all have any purpose or
> implications?
> --
> Thanks,
> Oskar
|||Hi Wayne,
Yup, constantly at 50 %.
Wondering what this could mean and is it OK or not.
By the way I have SQL Server: Cache Manager: Cache Hit
Ratio steady at 70%.
Thanks,
Oskar
>--Original Message--
>I have never found a situation where that counter
provided anything
>useful... It has the same meaning as the data cache hit
ratio, but applies
>to log reads from the log cache.. ( I am not aware of any
method to
>configure the log cache either...)
>Is your log cache hit ratio < 90%?
>
>--
>Wayne Snyder, MCDBA, SQL Server MVP
>Mariner, Charlotte, NC
>www.mariner-usa.com
>(Please respond only to the newsgroups.)
>I support the Professional Association of SQL Server
(PASS) and it's
>community of SQL Server professionals.
>www.sqlpass.org
>"Oskar" <anonymous@.discussions.microsoft.com> wrote in
message[vbcol=seagreen]
>news:1d8c01c4b752$e8163fb0$a501280a@.phx.gbl...
Hit
>
>.
>
|||Wayne,
I've never bother with this counter much at all? What is it really
measuring? Rollbacks? Reading from inserted/deleted tables in triggers?
Brian
"Wayne Snyder" <wayne.nospam.snyder@.mariner-usa.com> wrote in message
news:evKwbO2tEHA.3476@.TK2MSFTNGP14.phx.gbl...
> I have never found a situation where that counter provided anything
> useful... It has the same meaning as the data cache hit ratio, but applies
> to log reads from the log cache.. ( I am not aware of any method to
> configure the log cache either...)
> Is your log cache hit ratio < 90%?
>
> --
> Wayne Snyder, MCDBA, SQL Server MVP
> Mariner, Charlotte, NC
> www.mariner-usa.com
> (Please respond only to the newsgroups.)
> I support the Professional Association of SQL Server (PASS) and it's
> community of SQL Server professionals.
> www.sqlpass.org
> "Oskar" <anonymous@.discussions.microsoft.com> wrote in message
> news:1d8c01c4b752$e8163fb0$a501280a@.phx.gbl...
>
What would be the optimum percentage for the Log Cache Hit
Ratio?
Does this indicator at all have any purpose or
implications?
Thanks,
Oskar
I have never found a situation where that counter provided anything
useful... It has the same meaning as the data cache hit ratio, but applies
to log reads from the log cache.. ( I am not aware of any method to
configure the log cache either...)
Is your log cache hit ratio < 90%?
Wayne Snyder, MCDBA, SQL Server MVP
Mariner, Charlotte, NC
www.mariner-usa.com
(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org
"Oskar" <anonymous@.discussions.microsoft.com> wrote in message
news:1d8c01c4b752$e8163fb0$a501280a@.phx.gbl...
> Hi,
> What would be the optimum percentage for the Log Cache Hit
> Ratio?
> Does this indicator at all have any purpose or
> implications?
> --
> Thanks,
> Oskar
|||Hi Wayne,
Yup, constantly at 50 %.
Wondering what this could mean and is it OK or not.
By the way I have SQL Server: Cache Manager: Cache Hit
Ratio steady at 70%.
Thanks,
Oskar
>--Original Message--
>I have never found a situation where that counter
provided anything
>useful... It has the same meaning as the data cache hit
ratio, but applies
>to log reads from the log cache.. ( I am not aware of any
method to
>configure the log cache either...)
>Is your log cache hit ratio < 90%?
>
>--
>Wayne Snyder, MCDBA, SQL Server MVP
>Mariner, Charlotte, NC
>www.mariner-usa.com
>(Please respond only to the newsgroups.)
>I support the Professional Association of SQL Server
(PASS) and it's
>community of SQL Server professionals.
>www.sqlpass.org
>"Oskar" <anonymous@.discussions.microsoft.com> wrote in
message[vbcol=seagreen]
>news:1d8c01c4b752$e8163fb0$a501280a@.phx.gbl...
Hit
>
>.
>
|||Wayne,
I've never bother with this counter much at all? What is it really
measuring? Rollbacks? Reading from inserted/deleted tables in triggers?
Brian
"Wayne Snyder" <wayne.nospam.snyder@.mariner-usa.com> wrote in message
news:evKwbO2tEHA.3476@.TK2MSFTNGP14.phx.gbl...
> I have never found a situation where that counter provided anything
> useful... It has the same meaning as the data cache hit ratio, but applies
> to log reads from the log cache.. ( I am not aware of any method to
> configure the log cache either...)
> Is your log cache hit ratio < 90%?
>
> --
> Wayne Snyder, MCDBA, SQL Server MVP
> Mariner, Charlotte, NC
> www.mariner-usa.com
> (Please respond only to the newsgroups.)
> I support the Professional Association of SQL Server (PASS) and it's
> community of SQL Server professionals.
> www.sqlpass.org
> "Oskar" <anonymous@.discussions.microsoft.com> wrote in message
> news:1d8c01c4b752$e8163fb0$a501280a@.phx.gbl...
>
Log Cache Hit Ratio
Hi,
What would be the optimum percentage for the Log Cache Hit
Ratio?
Does this indicator at all have any purpose or
implications?
--
Thanks,
OskarI have never found a situation where that counter provided anything
useful... It has the same meaning as the data cache hit ratio, but applies
to log reads from the log cache.. ( I am not aware of any method to
configure the log cache either...)
Is your log cache hit ratio < 90%'
Wayne Snyder, MCDBA, SQL Server MVP
Mariner, Charlotte, NC
www.mariner-usa.com
(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org
"Oskar" <anonymous@.discussions.microsoft.com> wrote in message
news:1d8c01c4b752$e8163fb0$a501280a@.phx.gbl...
> Hi,
> What would be the optimum percentage for the Log Cache Hit
> Ratio?
> Does this indicator at all have any purpose or
> implications?
> --
> Thanks,
> Oskar|||Hi Wayne,
Yup, constantly at 50 %.
Wondering what this could mean and is it OK or not.
By the way I have SQL Server: Cache Manager: Cache Hit
Ratio steady at 70%.
--
Thanks,
Oskar
>--Original Message--
>I have never found a situation where that counter
provided anything
>useful... It has the same meaning as the data cache hit
ratio, but applies
>to log reads from the log cache.. ( I am not aware of any
method to
>configure the log cache either...)
>Is your log cache hit ratio < 90%'
>
>--
>Wayne Snyder, MCDBA, SQL Server MVP
>Mariner, Charlotte, NC
>www.mariner-usa.com
>(Please respond only to the newsgroups.)
>I support the Professional Association of SQL Server
(PASS) and it's
>community of SQL Server professionals.
>www.sqlpass.org
>"Oskar" <anonymous@.discussions.microsoft.com> wrote in
message
>news:1d8c01c4b752$e8163fb0$a501280a@.phx.gbl...
>> Hi,
>> What would be the optimum percentage for the Log Cache
Hit
>> Ratio?
>> Does this indicator at all have any purpose or
>> implications?
>> --
>> Thanks,
>> Oskar
>
>.
>|||Wayne,
I've never bother with this counter much at all? What is it really
measuring? Rollbacks? Reading from inserted/deleted tables in triggers?
--
Brian
"Wayne Snyder" <wayne.nospam.snyder@.mariner-usa.com> wrote in message
news:evKwbO2tEHA.3476@.TK2MSFTNGP14.phx.gbl...
> I have never found a situation where that counter provided anything
> useful... It has the same meaning as the data cache hit ratio, but applies
> to log reads from the log cache.. ( I am not aware of any method to
> configure the log cache either...)
> Is your log cache hit ratio < 90%'
>
> --
> Wayne Snyder, MCDBA, SQL Server MVP
> Mariner, Charlotte, NC
> www.mariner-usa.com
> (Please respond only to the newsgroups.)
> I support the Professional Association of SQL Server (PASS) and it's
> community of SQL Server professionals.
> www.sqlpass.org
> "Oskar" <anonymous@.discussions.microsoft.com> wrote in message
> news:1d8c01c4b752$e8163fb0$a501280a@.phx.gbl...
> > Hi,
> >
> > What would be the optimum percentage for the Log Cache Hit
> > Ratio?
> >
> > Does this indicator at all have any purpose or
> > implications?
> >
> > --
> > Thanks,
> > Oskar
>
What would be the optimum percentage for the Log Cache Hit
Ratio?
Does this indicator at all have any purpose or
implications?
--
Thanks,
OskarI have never found a situation where that counter provided anything
useful... It has the same meaning as the data cache hit ratio, but applies
to log reads from the log cache.. ( I am not aware of any method to
configure the log cache either...)
Is your log cache hit ratio < 90%'
Wayne Snyder, MCDBA, SQL Server MVP
Mariner, Charlotte, NC
www.mariner-usa.com
(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org
"Oskar" <anonymous@.discussions.microsoft.com> wrote in message
news:1d8c01c4b752$e8163fb0$a501280a@.phx.gbl...
> Hi,
> What would be the optimum percentage for the Log Cache Hit
> Ratio?
> Does this indicator at all have any purpose or
> implications?
> --
> Thanks,
> Oskar|||Hi Wayne,
Yup, constantly at 50 %.
Wondering what this could mean and is it OK or not.
By the way I have SQL Server: Cache Manager: Cache Hit
Ratio steady at 70%.
--
Thanks,
Oskar
>--Original Message--
>I have never found a situation where that counter
provided anything
>useful... It has the same meaning as the data cache hit
ratio, but applies
>to log reads from the log cache.. ( I am not aware of any
method to
>configure the log cache either...)
>Is your log cache hit ratio < 90%'
>
>--
>Wayne Snyder, MCDBA, SQL Server MVP
>Mariner, Charlotte, NC
>www.mariner-usa.com
>(Please respond only to the newsgroups.)
>I support the Professional Association of SQL Server
(PASS) and it's
>community of SQL Server professionals.
>www.sqlpass.org
>"Oskar" <anonymous@.discussions.microsoft.com> wrote in
message
>news:1d8c01c4b752$e8163fb0$a501280a@.phx.gbl...
>> Hi,
>> What would be the optimum percentage for the Log Cache
Hit
>> Ratio?
>> Does this indicator at all have any purpose or
>> implications?
>> --
>> Thanks,
>> Oskar
>
>.
>|||Wayne,
I've never bother with this counter much at all? What is it really
measuring? Rollbacks? Reading from inserted/deleted tables in triggers?
--
Brian
"Wayne Snyder" <wayne.nospam.snyder@.mariner-usa.com> wrote in message
news:evKwbO2tEHA.3476@.TK2MSFTNGP14.phx.gbl...
> I have never found a situation where that counter provided anything
> useful... It has the same meaning as the data cache hit ratio, but applies
> to log reads from the log cache.. ( I am not aware of any method to
> configure the log cache either...)
> Is your log cache hit ratio < 90%'
>
> --
> Wayne Snyder, MCDBA, SQL Server MVP
> Mariner, Charlotte, NC
> www.mariner-usa.com
> (Please respond only to the newsgroups.)
> I support the Professional Association of SQL Server (PASS) and it's
> community of SQL Server professionals.
> www.sqlpass.org
> "Oskar" <anonymous@.discussions.microsoft.com> wrote in message
> news:1d8c01c4b752$e8163fb0$a501280a@.phx.gbl...
> > Hi,
> >
> > What would be the optimum percentage for the Log Cache Hit
> > Ratio?
> >
> > Does this indicator at all have any purpose or
> > implications?
> >
> > --
> > Thanks,
> > Oskar
>
Subscribe to:
Posts (Atom)