There are different types of production DBA's. Some manage databases that are internally developed, and they need to know the structures, code and have a good knowledge of performance...

From what you have posted, I can only guess what your problem might be. It looks like you are doing the correct thing, but you haven't posted enough information...

matsinopoulos (1/4/2009)

---

[font="Comic Sans MS"]

Hi,

I have come across this problem myself in the past, and I found the solution here:

http://www.sqljunkies.com/WebLog/ktegels/articles/SigningSQLCLRAssemblies.aspx

Generally, the assembly you are trying to deploy needs to be signed...

Yes. The only exception is SQL Express which you have to download the SP2 installer binaries and this will update the installation to SP2. The Service Pack installer...

What version SQL is this for, and is it x86 or x64? I would suspect that you are getting multi-page allocations from the VAS/MTL and that you are on...

You can also query the sys.stats DMV to findout information about what statistics exist on particular tables. You can join it to the sys.stats_columns DMV to get column info.

On the SQL Server, check the status of the SQL Agent in Services.msc and see if it is stuck in the starting state. If it is, try restarting it...

I would only recommend number 1, a backup/restore of the databases post migration testing. I have used backup/restore of a full backup with norecovery, and then log backups/restores to...

One other thing:

Is there a specific performance issue that you are having, or are you looking to understand why the counters for the page file are what they are information...

What is the average value of the Memory: Available MB's on the server? If it is higher than 150MB then I don't think that you have a Memory bottleneck...

FNS (12/30/2008)

---

If a server keeps running out of space for the tempdb one option seems to be, move tempdb to a drive with more space. 😀

However, what's wrong with just...

Check the package that they used to move the Packages between instances, that would be the most likely suspect. If it was a transfer objects task in BIDS then...

Dave,

First, what is your servers hardware and software configuration? I see you say it is x64, but how much memory does it have, is it a dedicated SQL server,...

Perry Whittle (12/18/2008)

---

well, depending on where you read. MSDN states that AWE is only available for 32bit Ent and Dev sql2005. Technet states AWE available for Std, Ent and Dev....

I don't know of one. The syslogin view has a column for each of the server roles that is a bit field in both 2000 and 2005, so you...