Thanx For the response guys, i will read up on the matter.
Hi Guys Thanx for the response.
Can you tell me why i never received these errors when sql only had 1.7 Gig RAM?
Why does sql suddenly get memory...
I am a bit stumped.
I have a SS2000 enterprise Edition instance. Up until 2 days ago it had performance issues, related directly to huge...
I know for parttioning or just general filegroup administration etc, it is best practice to split your data files on seperate disks, same...
Thanx A million for your input Joe and ndinakar, i will be meeting with the Dell vendor soon.
Thank YOu i will run these scripts.
So what solution do you reccomend?
If i search fro SQL Lite on the net, i only find an oracle/mysql tool, exactly what sql lite are you refferring to? Is this in terms of...
Interesting you say that, the instance is currently on a SAN.
I was reccomending that it be taken off the SAN, do you reccomend , local RAID...
Well i cannot , it is a single update statement joinging to a view, thats it, but DTA keeps falling over ?
Could it have somethig to do with the...
Is anyone else experiencing problems with DTA when query tuning?
Basically DTA only works is i try tune a very simple query, like a simple...
How do you backup the database ? DO you use SAN snap/clone technology ? How long does your backup take ?
Output from @@VERSION from my 64bit installations.
Microsoft SQL Server 2005 - 9.00.2153.00 (X64) May 9 2006 13:58:37 Copyright (c)...
Separate names with a comma.