Database

PHP Version

PHP Memory Limit

SSH Access

SSH Key

Reverse Proxy

Ex: Varnish. Can see if varnish exists by running "service --status-all" from command line.

Alternatively, see if they have the Varnish module installed (on D6, they'll need to have Pressflow as well)

Otherwise, may have to examine the service plan.

Key-Value Store

Apache Solr

service --status-all OR examine Drupal search settings (should have Apachesolr module and/or Search API)

drush pml --no-core --type=module --status=enabled | grep solr

OpCode Cache

CSS/JS Aggregation

Page Caching

Version Control

Drush

Files Directory Size

Run "du -h files"; this gives you total size at the bottom along with size on other directories/files. May be

worth it to see what size is with imagestyle/imagecache directories excluded: "du -h --exclude=styles"

Database Size

Run "mysqldump -uusername -ppassword databasename > db_backup.sql" then "du -h db_backup.sql"

or

Run the following query that lists the sizes of all the available databases.

SELECT table_schema AS "Database", 
ROUND(SUM(data_length + index_length) / 1024 / 1024, 2) AS "Size (MB)" 
FROM information_schema.TABLES 
GROUP BY table_schema;

Other “Files Directories”

Codebase Structure

Are there non-standard directories? Is all custom code in sites/all/modules (or appropriate multisite

directories)?

Multisite

Non-Drupal Code

Contrib Codebase Quality

Custom Codebase Quality

Theme Layer Code

Is the Drupal API used well? Are templates misused (tons of PHP in templates instead of

preprocess functions)?

With drush installed run this command:

drush pml --no-core --type=module --status=enabled | wc -l

Content Types

Run either:

echo "SELECT COUNT(*) FROM node_type" | drush sqlc

OR

$ mysql -uusername -ppassword databasename
> SELECT COUNT(*) FROM node_type;

Views

Run either:

echo "SELECT COUNT(*) FROM views_view" | drush sqlc

OR

$ mysql -uusername -ppassword databasename
> SELECT COUNT(*) FROM views_view;

On D6 you can get the list of all views code and db from the views_cache table with the following query:

SELECT COUNT(*) FROM `cache_views`
WHERE cid LIKE 'views_default:%';

The query only shows views that are not in code. The best solution on D7 is to use drush:

drush views-list --status=enabled

This will five you a summary at the end of both code and db views.

Taxonomy

In D6 you can get a table list of Vocabularies, # of terms, and content types used on with the following query:

SELECT v.name, COUNT(DISTINCT td.tid) as '# of terms', CONCAT_WS(', ', vnt.type) as 'used on'
FROM
  vocabulary v
  LEFT JOIN term_data td ON v.vid = td.vid
  LEFT JOIN vocabulary_node_types vnt ON v.vid = vnt.vid
GROUP BY v.name
ORDER BY v.vid ASC;

In D6 display list of roles and users per role

SELECT r.name, COUNT(ur.uid) as 'users'
FROM
  role r
  LEFT JOIN users_roles ur ON r.rid = ur.rid
GROUP BY r.name

Server Response

This will vary between requests; for a quick idea, load the page in question with the Network tab open and

the browser cache disabled and see how long it takes for the initial request of the HTML document to be

returned.

Render time

How long does it take for the webpage to actually render? This is best represented by the red line in the Google

Network tab, which represents the "load" js event (when all images, stylesheets, js files, and other assets

are loaded). The blue line represents the DOMContentLoaded event and is less important for our purposes.

What's the PageSpeed Insights score for the URL you're investigating? Use the mobile speed and the desktop

speed (mobile/desktop) in the audit.

Image Optimization

Is the site effectively using image styles to make sure that images are an appropriate size? Bonus points if they

have a system in place to handle responsive images.