Viewing 6 posts - 1 through 6 (of 6 total)
Heya
I suppose the easiest way to figure out what is going on will be to use a tool called SQL profiler you can normally find this under client tools under...
June 7, 2011 at 12:58 am
Heya!!
You could try some fancy SQL, be be aware some of this TSQL code does different things with different versions of SQL, but I am hoping you are using at-least...
June 5, 2011 at 5:52 pm
Heya!
First of all I have to say "Tut tut" if you have a database server on a SAN or NAS environment the SQL engine should be the absolute last thing...
June 5, 2011 at 5:35 pm
Heya!!
Have you thought about using MSSQL's replication agent, once it is set up correctly it manages all the hard stuff for you.
If you need a second to second copy of...
June 5, 2011 at 5:28 pm
Heya!
A LUN is just like a disk partition, when it comes to a SAN environment normally the bottle neck is at the IO going from the SAN to the server.
So...
June 5, 2011 at 5:24 pm
Heya!!
High transact database are notorious for getting fat real quick.
I would advise running a simple little script every night to make sure that it is not storing empty space in...
June 5, 2011 at 5:20 pm
Viewing 6 posts - 1 through 6 (of 6 total)