Event Type: Error Event Source: SQLH2PerfCollector Event Category: None Event ID: 60 Date: 7/14/2009 Time: 5:56:52 AM User: N/A Computer: XXXXXX...
Having some problems using the SQL Server Health and History tool. We have a mixture of SQL Server 2005 (standard and EE) and I'm using SQL Server...
Thanks for the links, but what I'm looking for is a way to set up a SQL Alert based on the blocked process threshold parameter. BOL says it is...
SQL Server 2005 Books Online blocked process threshold Option Use the blocked process threshold option to specify the threshold, in seconds, at...
According to BOL you can configure an Alert based on the the Blocked Process Threshold configuration parameter, but I'm having some problems figured...
Like I said in my first post, I'm already using the SQLAgentReaderRole to allow the developers to see their jobs and view the job output, but they...
We have a group of jobs that are scheduled on SQL Server and managed by a team of developers. In SQL 2000 we created an account the development team...
What about the /3GB switch? This would allow SQL Server to use a 3GB address space and additional memory above the 4GB bar for data buffers when AWE...
We have a 64 bit server with 4GB of RAM and I'm installing SQL 2005 standard edition. I'm looking for recommendations on what to set the maximum...
No, restore on same server.
Nothing other than the error above that was also found on the restore job. Successfully restored backup to another server.
DBCC CHECKDB reports no problems. Production and report database are on the same server (very robust) we have a separate database to prevent any...
Each morning we take a backup of a production database and restore it to another database for reporting purposes using a RESTORE REPLACE. This job...
Thanks, we do have one table that accounts for over 50% of the database size, I'll offer up this suggestion and see what feedback I get.
<<one use of filegroups that i do like is to place the data for a very large table in its own file group. all other data and all indexes in the...
We have a server with a single raid five array for all data files and tlogs. We've been having a discussion concerning the merits of creating...
We were able to solve the problem by building the update dynamically and executing it via sp_executesql. This prevented the transfer of millions of...
Update<br /><br />Back ground:<br /><br />vw_order references a table on the linked server that has approx. 5 million rows and is defined on the...
I think a Stored Procedure is going to be the only viable solution, guess we'll have to wait until the performance hit outweighs their fear of...
So with SQL 2005 on a 32 bit platform you must specify the /PAE switch in the boot.ini before SQL will be able to make use of the memory above 2GB??...
Separate names with a comma.
