Hmmm, would it not depend on frequency? If you inserted 5000 rows into 100 pages per second then they wouldn't be discarded right away on account of the LRU algorithm?...

What do you mean by automatically?

I ran out of ideas for alerting too~ read that the hit ratio is pointless and nobody complains of page life way below 300....

No, I'm saying I guess it IS heavy OLTP? Manipulate in memory -> spew to disk -> repeat

Either that or the overhead of retrieving from disk everytime a query is...

GilaMonster (10/4/2013)

---

That was a poor recommendation 8 odd years ago when servers had maybe 4GB of memory. These days it's...

Hi all,

Sorry for the lack of response, I just got back from SQL Saturday and had no net there :f

Yes, it is 2 RAID5 sets (I'm guessing 3/4 disks per...

Doesn't matter now, was able to change it into a single query:

SELECT @@SERVERNAME, null, ''SQLAgent not running on '' + @@SERVERNAME, GETDATE()

FROM MASTER.dbo.sysprocesses

...

Hi,

Why not just see it in the GUI? 😮 This will do the trick anyways:

with t1 as (SELECT @@SERVERNAME server, sj.[name] name,

msdb.dbo.agent_datetime(run_date,run_time) start_time,

run_date run_date,

run_time run_time,

replicate('0', 6-len(run_duration)) + cast (run_duration as...

ALZDBA (8/14/2013)

---

With linked servers, the provided logins are always SQLUsers ! ( no windows domain accounts )

I don't use linked servers to gather inventory information from my sqlserver instances.

I...

Hi,

It is not working fine:

2013-08-14 12:05:00.97 Logon Login failed for user 'dom\svcusr'. Reason: Attempting to use an NT account name with SQL Server Authentication.

The restore executing user doesn't have permissions on that folder. I had the same issue earlier when I attempted to backup a database to the F: drive. Copy the files...

Damn overflows -_ changed from smallint to int to resolve the issue (although I then had to update the oracle table too).

OK you can ignore this thread. I fixed it by using row_number() in the subquery like:

row_number() over (partition by instance, db_name order by coll_date desc) rnk

Should have remembered it =/...

This?

SELECT CASE WHEN act_type.act_type_sc = 'ADD INFO INTERN' and instr(act_reg.act_rmk,'closed')>0 then 1

WHEN act_type.act_type_sc = 'ADD INFO P/C' and instr(act_reg.act_rmk,'closed')>0 then 1

else 0 end as colName

from...

Do people monitor the transactions/sec counter? If so do you tend to do it as per second count or longer?

I'm currently thinking of taking it & doing transactions/min since...

We only tend to have locking issues on the one database so I don't see much urgency for this being used (rather than going to the server).

Will take a look...