Hi Justing,

If you have network communications and/or clustering, and you use domain accounts for SQL Service and SQL Agent, then you might find that they are required to have local...

Hi Jeet,

DBREINDEX and INDEXDEFRAG are not one and the same thing. DBREINDEX will rebuild the entire index structure, update stats, and if the table has a clustered index, set an...

Hi NHM,

Another couple of tools I have used, along with those that Carl has mentioned, are SQLIO (MS tool) and IOMeter. These tools allow you to gather raw performance stats...

Hi Karthikeyan

As others have hinted before when you asked about Indexes, I think you could do with reading the following:

• Books OnLine (BOL)
• A book like 'Inside SQL Server 2000' by Kalen...

Hi Delsouc,

Had some experience with testing out Ramdisks. We found that there were some benefits performance-wise, but not as much as expected because we simply moved the throttle points (no quite...

Just as an aside...

If you were running Win 2000 Adv Svr, and had the 4GB RAM in place, your /3GB switch should work. You would not need to use the /PAE...

Hi John,

I would second a lot of what Carl has said, especially with regards to the number of spindles. Don't be fooled by the size of the disks, you'll more...

Hi Rowdy,

My understanding is that this is exactly what you should see. If a job is already running, then I don't believe it will spawn a 2nd, 3rd, etc. job. Hence,...

Ok, SQLBill is right, sorry (using the wrong terms), it's actually process IDs that you'll kill, and yes, you need to make sure...

Hi victord,

Found this in the sqlservercentral scripts

http://www.sqlservercentral.com/scripts/viewscript.asp?scriptid=30

Rgds

Ian G

Hello victord,

You need to kill all but your own spid to then be able to set it to 'single user' mode.

I haven't got the script handy, but I think there...

Hello webrunner,

I was in the same position as you about 4 yrs ago - a developer who became a dba. What I found the best was to first of all...

Hi Janet,

I think you have a lot to offer and would enjoy reading your articles more if I felt you were not using them to make a dig at someone...

With 8GB of RAM, you'll also need to use the /3GB switch with the /PAE switch, if you want to make use of greater than 6GB for SQL Server (otherwise 2GB...

Colin's points are very pertinent, especially concerning the number of spindles available. We have seen major differences in performance, by having the luxury of being able to test multiple subsystem senarios...