Thanks for the reply.

But I have read this and it's not related.

I think this may be file fragmentation as both drives (log and db) sits at about 99% and this...

Hi there,

Thought it would be easier to reply to this thread instead of creating a new one.

I have a question regarding these snapshots. As far as I know it should...

I'm so sorry 🙂

I was under the impression I could post issues regarding Oracle as well 🙂

Hi Jo, yes I know, luckily imp and exp are backward compatible (ie. 11g...

This is Oracle, not SQL. The reason why backup and restore (RMAN) won't work is because we are upgrading to 11g from 9i.

Thus I think expdp and impdp will be...

Thanks, I knew that question was a bit too far fetched

Okay, never mind, that was a stupid question 😛

Apologies for asking this before reading the post, but for some reason I was thinking of this possibility the whole morning 🙂

Thanks!

I have one question, may be a simple question but wondering if it is possible.

I know that it is possible to create an additional ldf. But is it possible to...

What SQL 2008 version is it? R2? If so, on which Windows version are you installing it on?

Thanks for the reply:

1. No, it is readwrite

2. We have over 900gb left on the ASM for that diskgroup.

We have always only extended the datafiles (currently 7 datafiles)

I want to...

Okay, so now (as expected), the databases have more reads whereas the logs have more writes.

Tempdb is under alot of strain though.

The only problem is, I need to find the...

Thanks a lot, perfect solution 🙂

Thanks for the reply man 🙂

It's never about how simple the query is, it's about how efficient the query is. It's like putting a V8 into a chevy spark and hoping for good fuel consumption...

Nevermind, I found the link 🙂

For those interested have a look - very interesting book revolving around just the hardware aspects of a SQL environment.

http://www.red-gate.com/products/dba/sql-virtual-restore/entrypage/sql-server-hardware-ebook

Cheers