Viewing 15 posts - 31 through 45 (of 286 total)
Add sys.dm_exec_requests and sys.dm_exec_sessions to the query. Something like this:
SELECT TOP 50 a.*,
(SELECT SUBSTRING(text, statement_start_offset/2 + 1,
(CASE WHEN statement_end_offset = -1
THEN LEN(CONVERT(nvarchar(max), text)) * 2
ELSE statement_end_offset
END - statement_start_offset)/2)
FROM...
February 28, 2011 at 9:46 am
Here is what I document:
1) SQL Server inventory (servers, versions, editions, service accounts, SQL Sever services on each server, number and name of named instances)
2) Hardware configuration (RAID levels, where...
February 27, 2011 at 9:32 am
Try to use different tools than TOAD for start (for example sqlcmd or SQL Server Management Studio) and see if it works.
February 24, 2011 at 6:49 am
Use DMV for this:
SELECT TOP 50
SUM(qs.total_worker_time) AS total_cpu_time,
SUM(qs.execution_count) AS total_execution_count,
COUNT(*)...
February 24, 2011 at 6:46 am
Good point.
You can split your job to several jobs as one of the options. Run separate jobs for different databases or large tables.
Also, try to review jobs schedules. Reindex...
February 20, 2011 at 9:00 am
If this will be useful - keep in mind that when you use NVARCHAR or NCHAR data types in will take almost twice more space than VARCHAR and CHAR.
February 19, 2011 at 4:52 pm
We had these errors for a while (in most cases when Index rebuild or reorganize jobs were running). SQL Server was installed on Windows 2003 64 bit, database files on...
February 19, 2011 at 3:14 pm
You can use sp_help_job @execution_status = 0. This will return list of jobs that currently run. Save results to the Temp table and then stop jobs one by one with...
February 19, 2011 at 12:28 pm
David Benoit (2/17/2011)
magasvs (2/17/2011)
You can find cache size for the objects with this query:
Nice! Did you write this or did you find it somewhere? I started writing something like this...
February 18, 2011 at 11:47 am
You can find cache size for the objects with this query:
SELECT db_name(database_id) dbname,page_type,
SUM(CASE WHEN ([is_modified] = 1) THEN 1 ELSE 0 END) AS DirtyPageCount,
SUM(CASE WHEN ([is_modified] = 1)...
February 17, 2011 at 8:42 am
You can check SQL Server logs. When trace started SQL Server logs event: "SQL Trace ID 3 was started by login NNN". The same message has SPID for the process...
February 17, 2011 at 6:44 am
Can you run package from command line using dtexec?
February 17, 2011 at 6:28 am
Run SQL Server Profiler. Change compatibility level for the database to 2008. Run you reports using GUI. Go back to Profiler and find the query. Do it for your all...
February 15, 2011 at 5:27 pm
This article has description of this bug in SQL 2005. May be it will be helpful to you as well.
February 15, 2011 at 5:18 pm
Sysxlogins is system table that existed in master database. Syslogins is view based on this table. Sysxlogins table doesn't exist in SQL Server 2005 any more.
February 15, 2011 at 5:09 pm
Viewing 15 posts - 31 through 45 (of 286 total)