SQLServer Error: 802, 701, 733

03/08/2010 - 15:03 von Bernd Maierhofer | Report spam
SQL Server 2008 on Win2008 R2 x64 Server, 8 GB RAM - virtualisiert VMWare
ES-Server

Jeden Sonntag laufen Reorgansiation, der Rebuild der Indices schlàgt fehl:

[298] SQLServer Error: 701, There is insufficient system memory in resource
pool 'internal' to run this query. [SQLSTATE 42000]
...
[298] SQLServer Error: 802, There is insufficient memory available in the
buffer pool. [SQLSTATE 42000] (SaveAllSchedules)


Danach ist der Server nihct mehr erreichbar:

[298] SQLServer Error: 773, SQL Server Network Interfaces: The requested
security package does not exist [SQLSTATE 08001]
...
[298] SQLServer Error: 773, A network-related or instance-specific error has
occurred while establishing a connection to SQL Server. Server is not found
or not accessible. Check if instance name is correct and if SQL Server is
configured to allow remote connections. For more information see SQL Server
Books Online. [SQLSTATE 08001]

rebooten hilft, aber die Jobs sind natürlich nihct beendet. Kann mir jemand
eine Tip geben?

Danke!

Bernd Maierhofer
www.nutritional-software.at
 

Lesen sie die antworten

#1 Jörg Burzeja
03/08/2010 - 19:57 | Warnen spam
Am 03.08.2010 15:03, schrieb Bernd Maierhofer:

There is insufficient system memory in resource
pool 'internal' to run this query



Schau mal hier:

http://support.microsoft.com/kb/982854/en-us


Viele Grüsse
Jörg

++ Where Do you want to go tomorrow? ++
++ http://schneegans.de/usenet/microsoft-umzug/ ++

Ähnliche fragen