bala2 (8/22/2013)

---

Hi All,

We have Performance issue on of our Pord server 2005,where we are seeing I/O issues.While montring i could a high I/O values for the Database.

Database i/o

...

Your LUNs should be online all the time. You need to check with your SAN admin and look for possible problems. If you have a scheduled downtime window, I would...

That means that the object does not exist, or the account running the ALTER INDEX does not have enough permissions.

Try to find or validate that specific object inside the database....

After checking online with a DELL representative, and me checking with a former coworker too, we are going to try "flow control" setting, both sides: NIC level and run the...

better late than never 🙂

I am still having issues with the SAN (other issues) but this particular problem was solved. We added the fixed IPs , instead of default, and...

Perry Whittle (7/29/2013)

---

Even using a partitioning tool on an online cluster volume, i'm not sure this would be a wise thing to do, i assume this is what you are...

Perry Whittle (7/26/2013)

---

Not going...

jpettigrew (7/25/2013)

---

I cannot see the main backup drive in SQL cluster when attempting to do a restore. The backups for the cluster is stored on this drive. I only see...

How busy that table or database is? If you have users continuously using that table and running queries all the time, it will affect the shrink process and slow it...

Hi...

Not a requirement, but ideal.

In terms of permissions and schema changes, any non Clustered environment should do the trick, as long as you exactly recreate the same permissions you have...

I still do not know how those values changed but i modified an existing T-SQL script that I found via Google so I can proactively check for the same issue...

This is going to be a very interesting problem here at my job.

Of course I fixed it (for that particular table), but just had a conversation with one of the...

GilaMonster (7/19/2013)

---

Migrating a DB does not reseed identities. Check for jobs that may have done so, ask other DBAs, check the max value in the table and compare it to...

GilaMonster (7/19/2013)

---

Identity has never guaranteed unique numbers, just incrementing numbers. If the identity gets reseeded, SQL will start from the given number regardless of whether that number is already in...